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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
i didn't forget it ... i was leaving it for someone else, but you're welcome
anyway -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "filo666" wrote in message ... you forgot the must difficult one, when a new workbook is called ( I mean when you want to start a new workbook I want to call my form) I thougt about auto_open, but it works just with workbooks created before no with new workbooks I want that when the new workbook button is pushed (or the new option in the file menu) my form appears. tanks. "JulieD" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
Look at Chip Pearson's site on Application Level events
http://www.cpearson.com/excel/appevent.htm The application level event has an event that fires when a workbook is created. Private Sub xlApp_NewWorkbook(ByVal Wb As Workbook) the xlApp portion would depend on what object was used to instantiate application level events. -- Regards, Tom Ogilvy "filo666" wrote in message ... you forgot the must difficult one, when a new workbook is called ( I mean when you want to start a new workbook I want to call my form) I thougt about auto_open, but it works just with workbooks created before no with new workbooks I want that when the new workbook button is pushed (or the new option in the file menu) my form appears. tanks. "JulieD" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
got to make these MVPs work :)
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Charlie" wrote in message ... LOL, you left the impossible for the rest of us! When you start a new workbook you get... a NEW workbook. Empty. Unless I'm mistaken I didn't think you could start a new workbook and have it automatically pick up forms, modules, etc. from another workbook. Maybe I'm misunderstanding what the OP meant. "JulieD" wrote: i didn't forget it ... i was leaving it for someone else, but you're welcome anyway -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "filo666" wrote in message ... you forgot the must difficult one, when a new workbook is called ( I mean when you want to start a new workbook I want to call my form) I thougt about auto_open, but it works just with workbooks created before no with new workbooks I want that when the new workbook button is pushed (or the new option in the file menu) my form appears. tanks. "JulieD" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
Let me see if I understand; could run a form in a new object just if
previusly I have a workbook with the "Private Sub App_NewWorkbook" event?? this is it??? there in no way of run my form when a user double click the excel's icon??? "Charlie" wrote: See, I didn't know that. Thanks for the info. "Tom Ogilvy" wrote: Look at Chip Pearson's site on Application Level events http://www.cpearson.com/excel/appevent.htm The application level event has an event that fires when a workbook is created. Private Sub xlApp_NewWorkbook(ByVal Wb As Workbook) the xlApp portion would depend on what object was used to instantiate application level events. -- Regards, Tom Ogilvy "filo666" wrote in message ... you forgot the must difficult one, when a new workbook is called ( I mean when you want to start a new workbook I want to call my form) I thougt about auto_open, but it works just with workbooks created before no with new workbooks I want that when the new workbook button is pushed (or the new option in the file menu) my form appears. tanks. "JulieD" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to call a form
It probably is -depending on which Excel icon of course. But this grows into
a "what's theoretically possible" thing and those can get pretty extensive. Please tell us what this is for and why for a more practical approach. HTH. Best wishes Harald "filo666" skrev i melding ... Let me see if I understand; could run a form in a new object just if previusly I have a workbook with the "Private Sub App_NewWorkbook" event?? this is it??? there in no way of run my form when a user double click the excel's icon??? |
Reply |
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 |