PDA

View Full Version : Solved: beginning with userforms



choubix
07-08-2008, 07:36 PM
hello!

just wondering if you guys knew a good tutorial on how to manage userforms in vba. i am a bit at a loss there...

I have googled vba userforms etcetc but I didnt find anything compelling.

sorry for not being too specific but i am at an early stage with these things.

btw: do I call a userform the same way as a sub? (i will need to show the userform on a worksheet after a macro has run)

thanks!

choubix
07-08-2008, 08:53 PM
btw: is it possible to have a button diplayed on all the worksheets of a workbook (like in a frame) without having to duplicate this ubtton on every single worksheet please??

thx!

mdmackillop
07-09-2008, 12:17 AM
To show a userform (named as to suit)

Userform1.Show

You can create a custom toolbar to hold workbook specfic buttons.

Also, check out Site Links/Resources for useful sites

choubix
07-09-2008, 03:13 AM
thanks!

been improving today using the forms.
i am trying now to use 1 form as the main one. you click on a button and another form would open. (so form1 is for navigating and form 2,3,4.... would change the workbook)

how can i call form 2,3,4... when I click a button please?? it returns an error when i call form 2 in form1_Click()

thanks!

mdmackillop
07-09-2008, 05:30 AM
This should not be a problem, but consider using a multipage userform. A bit more work but more "professional"