PDA

View Full Version : link a user interface to another user interface



HM4
12-05-2007, 08:55 AM
Hi!
how can i link a userform to another using VBA? What code do i need to use? - using a MS Excel 2003.

What i want is to be able to click on button on the main userform that links and displays another userform.

Thanks

Bob Phillips
12-05-2007, 09:16 AM
I think you might have to explain yourself soemwhat. I for one have no ide by what you by a user interface.

ProteanBeing
12-05-2007, 10:13 AM
sub button1_click()
formname.show
end sub

I am assuming that the button is named button1
insert the name of the form for formname

This should work

HM4
12-05-2007, 10:24 AM
THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U