Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load VBA on Activated Sheet
Hey,
in Visual basic you can put in code to run when the form is loaded up. is there a way to do the same for Excel when a worksheet is loaded up? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load VBA on Activated Sheet
What you are looking for is event driven programming and the answer is yes.
On the worksheet you want to run the code... Right Click the Tab and select View Code. Just above the code window in the left had drop down box (General) select Worksheet. the drop down on the Right will give you all of the Events you can program against. You are looking for Activate. When you select the event a code stub will be added for you... -- HTH... Jim Thomlinson "RigasMinho" wrote: Hey, in Visual basic you can put in code to run when the form is loaded up. is there a way to do the same for Excel when a worksheet is loaded up? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load VBA on Activated Sheet
Private Sub Worksheet_Activate()
'do something End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "RigasMinho" wrote in message oups.com... Hey, in Visual basic you can put in code to run when the form is loaded up. is there a way to do the same for Excel when a worksheet is loaded up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warehouse load sheet - Help!! | Excel Discussion (Misc queries) | |||
Error sheet when macro's are not activated | Excel Programming | |||
Can I Somehow load a Spread Sheet thru a Scanner | Excel Worksheet Functions | |||
Load an array with Sheet names | Excel Programming | |||
VBA - Left Shift to be Activated when Sheet is selected. | Excel Programming |