| Thread | Last Post | Replies |
|
| Anyone know an answerr? | 17 Apr 2008 08:55 GMT | 1 |
Does anyone know anything at all about this problem: I have a worksheet containing a scroll bar, taken from the control toolbox. The code for this scrollbar'schange event copies information from
|
| WORD ART MESSAGE BY MACRO | 17 Apr 2008 08:36 GMT | 4 |
I am using excel 2007. is it possible that when you open excel file then a message should come up in wordart saying "SEE THIS" then after 5 seconds it disappear. Basically i want some sort of macro in excel file that when someone open the file a message should appear
|
| Format Text Boxes | 17 Apr 2008 08:17 GMT | 3 |
Hi - i've got some text boxes in my userform and the word wrap in the properties section doesnt seem to work the way Wrap Text works in an excel cell?
|
| reformatting "text" format for dates and numeric data | 17 Apr 2008 04:38 GMT | 3 |
I need to manipulate a LOT of historic excel files that had a LOT of different people that did the original data entry. The data are in columns, and consist of dates (Column B) and numeric values (Columns C- NN). But some of the date and numeric values are stored as text
|
| How do I convert HTML tags within cell to text? | 17 Apr 2008 04:00 GMT | 1 |
I have an XLS extract from a system that has included the HTML tags within the cell. How do I go about converting this to text where possible and removing it where not?
|
| From Immediate window to Text file - create a log file | 17 Apr 2008 03:05 GMT | 1 |
I have an application that different functions are publishing thing on the Immediate window. I would like to have all the output of the Immediate window saved on a text file - so creating some king of log file - is it doable?
|
| Re:Converting an Excel sheet to an XML file. | 17 Apr 2008 03:01 GMT | 4 |
I have an excel sheet by name "sheet1" and it contains some data in it . I want to convert this excel sheet into an XML file programmatically . Please consider this as urgent Regards,
|
| Formula Help | 17 Apr 2008 02:25 GMT | 1 |
I use a spreadsheet to calculate cost of a project which includes commission rate and profit. The commission is a percentage of the sell price (COST+TAX+MARK-UP). But the sell price
|
| Creating Splash Screen in Excel 2004 MacIntosh | 17 Apr 2008 02:21 GMT | 8 |
I have created a splash screen that works fine in Windows Excel but not on a MacIntosh. I am using Application.wait to have the splash screen appear for five seconds but on the Mac it will not disappear. From my testing it appears that on the Mac the splash screen is being ...
|
| conditional formatting | 17 Apr 2008 02:01 GMT | 1 |
OK, strange question. I would like to change the color of one cell, when I just select another cell. I know this can be done with Workbook_SheetSelectionChange.
|
| ScreenUpdating = FALSE | 17 Apr 2008 01:43 GMT | 2 |
I would like to turn off screen updating while my sub runs. If I turn off screen updating within the sub, it does not turn off. If I turn off screen updating in a second sub that calls the first, it turns off. Any thoughts why I have to use the 2nd sub - I would prefer to ...
|
| UserForm - Right-click a Textbox and Paste | 17 Apr 2008 00:35 GMT | 1 |
In a UserForm TextBox, is there a way to allow right-clicking? For example, I'd like to be able to right-click inside of a textbox and get the menu option to Paste. I know I can use Ctrl+v, but I'd like to know if it can be done completely from the mouse.
|
| Has anyone made a Deal or No Deal Gameboard? | 17 Apr 2008 00:12 GMT | 2 |
My school would like to play a version at a dinner dance and would like to project a DOND gameboard on the wall. We would like to be able to take off amounts once they are uncovered. Thanks
|
| linking worksheets programmatically | 17 Apr 2008 00:01 GMT | 1 |
I have two workbooks A and B. When the user opens workbook A, I would like to have Workbook A to create a link to worksheet1 from workbook B, which resides out on the network. I tried various UNC path syntax to workbook B, but it didn't work.
|
| Pop Reminder | 16 Apr 2008 23:55 GMT | 2 |
I have a excel spreadsheet that contains the date a request is received and the date the request is due to the customers. How do I create a popup that alerts the user three days prior to the due date, which request are due? I will need for the popup to activate everytime the ...
|