Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
Hi
for 2)when a user push a button in a excels sheet - create a macro e.g. sub runform() userform1.show end sub and assign the macro to the button 3)when cells(1,1)=cells(1,2) - put code against the worksheet_change() of the sheet e.g. Private Sub Worksheet_Change(ByVal Target As Range) if target.address = "$A$1" or target.address = "$B$1" then if Range("A1").Value = Range("B1").value then userform1.show end if end if End Sub 4)when a workbook is open - put code against the workbook_open() procedure e.g. Private Sub Workbook_Open() userform1.show End Sub if you need further information on implementing any of these please post back. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "filo666" wrote in message ... I made a form but I dont know how to run it; I need to run it in the following cases 1)when a new workbook is called 2)when a user push a button in a excels sheet 3)when cells(1,1)=cells(1,2) 4)when a workbook is open TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I call VBA subs from different spreadsheet from code behind form? | Excel Discussion (Misc queries) | |||
How do I call number values form one workbook to another workbook | Excel Worksheet Functions | |||
How Can I call any form or macro.. | Excel Worksheet Functions | |||
How can I call a macro or form. in the moment that enable any shee | Excel Worksheet Functions | |||
Add-In...form call | Excel Programming |