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
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
Last edited by HM4; 12-05-2007 at 09:30 AM.
I think you might have to explain yourself soemwhat. I for one have no ide by what you by a user interface.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
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