Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the best way of doing this and how.
This is what I want.... MultiPage1.Value =0 Cancel Next MultiPage1.Value =1 Previous Next MultiPage1.Value =2 Previous Finish Is it best to create one of each and then make then visible/invisible for each tab ( and how do you do this) Or is it best to generate each one on each tab seperately. If so, can you then group all the Nexts together to write one sub that will move to the next page rather than having to generage duplicate subs for each button. Both the above ways I have tried but stumble on both. 1st option I can't get the right syntax to make visible/invisible which I am trying to do under the MultiPage1_Change() which apparently isn't valid. 2nd option I can make a new collection of the next buttons but then don't know how to use that group to attach to code to raise the tab number. Can anybody help ? Thanking you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to cancel a cut command connected to arrow down | Excel Discussion (Misc queries) | |||
Syntax Problem : Grouping Buttons On A Multipage | Excel Programming | |||
Create Next and Previous Buttons on Userform | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming | |||
Cancel buttons in Msgbox | Excel Programming |