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