How to hide tabs, make them appear after specific user input

[ali_lum]

Hi,

I posted earlier, but since have made some good progress and figured some stuff out by myself!

I have nearly finished my project, but need to make the last real bit of code, then just some general tidying up.


What I want to do
- I currently have two tabs in a userform - one called 'main' and one called 'extra'.
- I want Main to always be shown to the user.
- I want Extra to be hidden (is it possible to make the tabs invisible?) and for this form to be shown only under a specific condition

I have a question on my userform (using Option Buttons):
"Did the customer ask about an extra product today?"

If the answer to this question is no
- When the user hits the command button (after filling out the rest of the form), do nothing special - just return all the values to the worksheet

If the answer is yes
- When the user hits the command button, I want them to be taken to the 'extra' tab. They will fill out some additional check-boxes, then hit another command box, which will return the info from both the 'main' and 'extra' sheets into the same row of the worksheet.


In brief: I want my 'extra' tab to be hidden, only to appear when 'yes' is selected, and for the results all to go back to the worksheet.

Can this be done?
Thank you for your help :D

[nathansav]

Google, MSGBOX vba

and i googled, hiding pages on tab control, got this.

http://answers.microsoft.com/en-us/o...c-64fa2ece7aa4

[ali_lum]

and i googled, hiding pages on tab control, got this.
http://answers.microsoft.com/en-us/o...c-64fa2ece7aa4

Thank you for quick response and the link.

However, the answers on that thread do not tell me how to do exactly what I require, only how to hide a control tab.

[nathansav]

Me.tabMyTabControl.Pages(0).Visible = False

that should do it, in the section marked Answer.

[ali_lum]

I can hide the tab easily -- all you need to do is change the properties of the multipage to : "Style: fmTabStyleNone.

This removes the tabs, which is great.

Now I just need my command button to send my users to the now hidden 'Extra' tab, if they have chosen 'yes' to my specific question. Any ideas?

[clabhart]

If your userform places the value of "YES" in a specific cell you could use an IF statement to refer directly to the cell and the result being the sheet being unhidden. For example

Please Login or Register  to view this content.

This assumes your sheet is already hidden

[ali_lum]

What I have done is made the two tabs invisible on my userform by changing the style properties.

Now, I just need the right code to get my command button to send the user to the hidden tab, if they select yes. Here's what I've tried, but it doesn't work:

Please Login or Register  to view this content.