| Thread | Last Post | Replies |
|
| Class Module Problem | 27 Jun 2006 06:07 GMT | 2 |
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 GMT | 1 |
Is there anyway to get symobl and tahoma fonts in the same text box for a Userform? -Abe
|
| how to convert excel to .xls file | 27 Jun 2006 06:04 GMT | 1 |
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 GMT | 1 |
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 GMT | 1 |
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 string | 27 Jun 2006 05:29 GMT | 1 |
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 Working | 27 Jun 2006 04:29 GMT | 1 |
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 Documentation | 27 Jun 2006 03:58 GMT | 1 |
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 module | 27 Jun 2006 03:36 GMT | 1 |
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 Form | 26 Jun 2006 23:57 GMT | 3 |
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 question | 26 Jun 2006 23:42 GMT | 1 |
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 criteria | 26 Jun 2006 22:55 GMT | 1 |
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 GMT | 1 |
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 working | 26 Jun 2006 22:44 GMT | 1 |
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 code | 26 Jun 2006 22:33 GMT | 1 |
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
|