| Thread | Last Post | Replies |
|
| Help with Visual Basic programming | 27 Feb 2006 01:52 GMT | 2 |
I'm trying to write a macro so that when information is entered into a form I have created it will be inputed automatically into one of the worksheets when I hit the submit button. I have been able to do this but need it to recognise that if there is all ready information in that ...
|
| Search Replace in VBA | 27 Feb 2006 01:46 GMT | 5 |
I tend to record all my actions in a macro and then hack around t create what i really need. This project is to download data from a web site using the web quer and then to create a pivot table of the data.
|
| Formatting text within VBA | 27 Feb 2006 01:04 GMT | 3 |
How can I (or can I) format a string to be written to a cell *before* it is put there? I'm encountering strings from html that I would like to correctly represent in Excel (e.g., using bold font for text between asterisks) without having to do it in situ within a cell. Any one of ...
|
| How to handle automation error? | 27 Feb 2006 00:56 GMT | 2 |
Have a .xla add-in and with one user only there is an automation error in the Workbook_Open event of this add-in. The problem is that although there is an error handler
|
| How do I copy validated lists | 26 Feb 2006 23:28 GMT | 4 |
Making a schedule 21 days across by 12 rows down. I want to make a drop down list of employees names and have the same list available in each cell. I use the data, validation steps to create the lists, but Excel automatically changes the coordinates of the data in each horizontal ...
|
| help, please | 26 Feb 2006 22:59 GMT | 2 |
A friend wants to do the following: "Workbook called SEMINARS. 3 sheets that are for 3 diff seminars. On the fourth sheet, I would like to call that the "ENTRY" sheet. On that sheet I want to have a row of info that says for example
|
| Excel 2003 very slow | 26 Feb 2006 21:51 GMT | 2 |
I have a workbook that works fine in excel 2002, but runs extremely slow in Excel 2003. For example, one macro which is fairly complicated but doesn't process a lot of sheets or a lot of cells, takes about 10 seconds in 2002 on a PII-350 with 128 mb RAM and Win 98SE, and takes ...
|
| Worksheet-template (HELP!) | 26 Feb 2006 21:40 GMT | 1 |
Can someone tell me in lamen's terms how to create a worksheet and them be able to make it a template or a form so that I can highlight everything and only delete the data just entered instead of the whole sheet? PLEASE HELP!
|
| dynamic data capture | 26 Feb 2006 21:21 GMT | 1 |
How do I take a "snapshot" of dynamic cell data in specific time frames (every 15 minutes, 30 minutes, etc)? The dynamic data is constantly being recalculated from a live feed. I need to be able to see where the data was back in time for establishing a trend.
|
| Isnumeric | 26 Feb 2006 20:20 GMT | 3 |
What else am I leaving out, still won't reconize just numbers If Not IsNumeric(TextBox1.Text) Then MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays" Exit Sub
|
| Location of Cell Between Embedded Chart | 26 Feb 2006 20:14 GMT | 3 |
I have a chart embedded on a worksheet. I would like to select the cell just below the chart. Is there a way of finding that location? Thanks, Bill
|
| Help with Lists | 26 Feb 2006 20:13 GMT | 4 |
I have a list on one sheet and would like to show the same list on anothersheet. The problem is, I want the list on sheet2 to be updated at the same time the list on sheet1 is changed so that both they are always the same. Both sheets are in the same workbook. Can anyone one ...
|
| Workbook Event | 26 Feb 2006 19:12 GMT | 1 |
I want a message box to appear when the value of a cell reaches a certain level. I've tried the following code in the 'ThisWorkbook' section but it just comes up with an error:
|
| Integrating Outlook, Word, Excel macros | 26 Feb 2006 18:53 GMT | 4 |
I posted this in the Outlook forum, but the replies in here always tend to be genius, so I thought I'd post it here as well. Summary: Everyday, I receive an email with an attachment. I open the attachment in word. Run a macro called Acknowledgements (specifically
|
| calculate blocks contained in a larger piece of wood | 26 Feb 2006 18:37 GMT | 3 |
I am trying to set up an Excel spreadsheet to calculate how many pieces of wood I can cut from a larger piece of wood and what would be the dimensions of the remaining wood, if any. For example; how many pieces of wood measuring 1.5" square x 2" length can be cut from a board ...
|