Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / June 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Class Module Problem27 Jun 2006 06:07 GMT2
I've got a Class Module that Prints certain sheets when selected by a
checkbox on my form however it has a syntax error when it tries to go to the
class module my code is as per follows:
Code from Form
Symbol and Tahoma fonts in same text box?27 Jun 2006 06:05 GMT1
Is there anyway to get symobl and tahoma fonts in the same text box for
a Userform?
-Abe
how to convert excel to .xls file27 Jun 2006 06:04 GMT1
I am using a userform to get employees id number and passwords.  I have the
id numbers and passwords on a hidden sheet.  I need to code in the submit
button on the form a way to search the hidden sheet for there id number and
password match and then if it does match take them to ...
Any easy way to conduct GARCH modeling?27 Jun 2006 05:58 GMT1
Trying to do GARCH modeling, any quick way to do it?
Simple VBA code is desirable
Obtain information from Excel?27 Jun 2006 05:39 GMT1
I have 48 pages (65,536 lines each) of data and need to extract details (ie,
all hours totalling 41 hours per week pasted to a new worksheet and the same
for 42 hours worked per week, 43 hours, etc.)  Is there a macro or something
I can use to do this?  I've already summed all ...
Replacing characters in cells string27 Jun 2006 05:29 GMT1
I need to seach all cells in Sheets(2) and replace any ;; character with ;
that may be present in the text of each cell.
I haven't the faintest idea how to do this.
Thank you.
msg Box Title Not Working27 Jun 2006 04:29 GMT1
msg = "Enter the Job Number...."
I am trying to add a custom title to the above to No Avail.
I tried :
msg = "Enter the Job Number....","My msg Box"
Excel Format Documentation27 Jun 2006 03:58 GMT1
Hi,
Is the Excel file format  BIFF8 specification available somewhere ?
is it available with the SDK ? if so how can we get it
Thanks !!
create event in class module27 Jun 2006 03:36 GMT1
Public WithEvents clsCbo As MSForms.ComboBox
Private Sub clsCbo_Change()
Call sbCboFil(clsCbo, g_DB, a.fnsrJi(clsCbo), True)
End Sub
Adding Checkboxes to a Form26 Jun 2006 23:57 GMT3
Is there a way to use VBA to add a certain number of checkboxes (or anything
else) to a userform?  For example, I may need anywhere from 3 to 7
checkboxes on a userform.  I would prefer to build just one instead of 5
different userforms.
Text to columns question26 Jun 2006 23:42 GMT1
I need help with this problem. I have two columns one that lists phon
numbers and the other one that lists the count.
I could easily do a text to columns however, some of the numbers i
sequence are shown with a -. i.e.2095381654-1655.
Conditional Formatting with multiple criteria26 Jun 2006 22:55 GMT1
I am able to use conditional formatting for, say, one specific "set" of
criteria, and please forgive, I am a completely noob with any kind of
programming, so you are getting the "layman's" version of the criteria I am
using:
multiple web queries in one worksheet?26 Jun 2006 22:47 GMT1
i have generated 4000 .iqy files which query a specific table on a
website. when i run an individual query, the data i want is extracted
perfectly. i need to be able to combine all these queries into one
worksheet and run them at once (or in batches of 500 or whatever number
Code is not working26 Jun 2006 22:44 GMT1
For some reason my code is not working, I am trying to print out sheet
based on what the main page selections are.  ie. On the main sheet ther
are checkboxes, beside each checkbox is the name of the sheet in a cell
Then there is a checkbox, and then in the cell next to that, there ...
e-mail code26 Jun 2006 22:33 GMT1
I am trying to e-mail two worksheets from a workbook using the following code
from Ron de Bruin;
Sub MailSheets()
   Dim wb As Workbook
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.