| Thread | Last Post | Replies |
|
| Need help creating VBA procedure for Open event | 17 Aug 2007 02:20 GMT | 1 |
I need to create a VBA procedure for the Open event of a workbook that will check to see if the macro security level is set to High, and if so, display a message advising the user to change the macro security level to Medium. Being a novice to VBA, can someone please show me how ...
|
| Macro Not Completely Working | 17 Aug 2007 02:19 GMT | 2 |
As you can see this macro should find a number less than 1000 and then color it. It finds the number, however will not color it, and also there may be multiple cells with less than 1000. Could you help me in getting this macro
|
| last cell without a blank | 17 Aug 2007 02:18 GMT | 6 |
I have a series of dates in cells a1:z1 and some numeric data in some of the cells a2:z32. I would like to find the last column that contains a value in any of the data cells (all columns after that contain a blank) and then select the date cell that corresponds to it. Can ...
|
| using checkbox to calculate another cell | 17 Aug 2007 02:18 GMT | 2 |
I have the following code in a macro for a checkbox and it gives a error of object required any suggestions? Private Sub CheckBox19_Click() If CheckBox19.Value = True Then
|
| Flash Screen/Timeout msg box | 17 Aug 2007 02:17 GMT | 2 |
I would like to create a flash screen window/message box/popup window which will close close automatically after specified time, how do I create it give me a basic idea. Thanks and Regards
|
| How to org my questions | 17 Aug 2007 02:14 GMT | 1 |
I want to have a way to quickly find the questions I asked on the discussion group, is it possible to build a personal folder? Clara
|
| Problems using Worksheet_Change | 17 Aug 2007 02:13 GMT | 1 |
Does someone knows if exist any way of getting the old value in this: Private Sub Worksheet_Change(ByVal Target As Range) ‘ for the new data coming is easy: New_data = Target.Value
|
| Simple Custom Function??? | 17 Aug 2007 02:10 GMT | 1 |
I'm trying to create a simple custom function. I'm trying to have the user input the row and column numbers in the function (like =MYFUN(1,2) referencing cell B1) and have it return the contents of that cell. So I thought I would use the following.
|
| print/save macros | 17 Aug 2007 02:09 GMT | 2 |
My print macro is currently like this Sub FinalOrderPrintWorkbook() Dim sht As Worksheet For Each sht In ActiveWorkbook.Worksheets
|
| Hide a worksheet | 17 Aug 2007 02:09 GMT | 3 |
I'd like to be able to hide a worksheet that I am using for data storage, how can I do this programmatically? Using the Excel menus?
 Signature Email address is not valid.
|
| Using formula in code | 17 Aug 2007 02:09 GMT | 1 |
I have the following formula which works fine in a worksheet: =IF(AND(N4>-1,N4<31)=TRUE,"1-30",IF(AND(N4>30,N4<61)=TRUE,"31-60",IF(AND(N4>60,N4<100)=TRUE,"61-99",IF(N4>99=TRUE,"100+","Error!")))) However, when I try to use VBA code to enter the formula using this ( which is ...
|
| screenupdating problem | 17 Aug 2007 02:08 GMT | 1 |
I have a macro in the following layout
> sub MyMacro() > application.screenupdating = false |
| Want VB form to show in Excel Worksheet | 17 Aug 2007 02:08 GMT | 1 |
Through the VB attached with Excel, I have built a form for users to fill out. I need to know how to make the form visible in an Excel worksheet so that when they open the excel file, the form is visible right away on the first worksheet.
|
| Picture Problems | 17 Aug 2007 02:07 GMT | 1 |
Just wondering I have multiple worksheets and on the main worksheet screen is my invoice page, all the rest is programming related. Now depeneding on the customer I want them to be able to click on a number and then their logo come onto the page at the bottom of the screen. I ...
|
| if statement | 17 Aug 2007 02:07 GMT | 1 |
I would like help writing some code that would run the code below if the value of cell a5 is the word "Fixed". Rows("5:13").Select Selection.EntireRow.Hidden = True
|