Make a box appear / disappear depending on drop down form selection

Hi,

Can any help!

Basically i have a drop down box, cover promotion, change of hours, salary increase, act up allowance and etc on

i want a box to appear if i chose promotion or change of hours only then if i dont, it will disappear, how can i do that?

Thanks appreciated

Kind regards

Excelyee

Try setting the 'visible' property of the object ... 'True' makes it visible and 'False' hides it.

Thanks, sorry where is the visible property?

You set the property in your code as in:

Please Login or Register  to view this content.

If you could post a copy of your file with a detailed explanation of what you would like to do, it would be easier to help.

Here a copy of my spreadsheet, what i would like to do is

If i select promotion, then roll 52 to 54 will appear and roll 49 to 51 will be disappear
If i select Acting up allowance, then only roll 50 will appear and the roll 49, 51-54 will disappear

is this possble?testing file xls.xls

Many thanks

What do you mean by

roll 52 to 54

What is a roll?

Sorry my error I meant row

Hi excelyee. I assumed that by "roll" you meant "row". Place the following code into the worksheet module for the sheet 'Personnel Change' (not into a regular module).

Please Login or Register  to view this content.

thank you so much, this is working perfectly!

appreciated your help :-)

My pleasure.

Hi ya,

If i protected the worksheet, the macro is no longer working, can you help?

Thanks

kind regards

Sandy

If the sheet is protected, the macro must first unprotect it, perform its task and then protect it again. Use the following code:

Please Login or Register  to view this content.

If you used a password to protect the sheet, then change the two new lines at the beginning and end of the macro to:

Please Login or Register  to view this content.

Thank you for your help

My pleasure.

Originally Posted by Mumps1

My pleasure.

Hi, sorry to be a pain, wander if u could help, is there a code I could use for example if they reply to no then macro tell them to move to the right questions or columns

What do you mean by

if they reply to no then macro tell them to move to the right questions or columns

Please be more specific with exactly what you would like to do step by step.

Originally Posted by Mumps1

What do you mean by Please be more specific with exactly what you would like to do step by step.

What I wanted to do is from the spreadsheet I have shown you last time, this time I want to use macro to tell me if I picked (for example promotion) from a drop down list then a message appear to tell me to complete (e.g. Column f) or direct me straight to that column? Is this possible?

Thank you

At the moment, the macro hides/unhides certain rows if you choose "Promotion" or "Acting Up Allowance". Unfortunately, we can't have the macro do something else if "Promotion" is chosen because that would confuse Excel. It wouldn't know what to do because you are asking it to do two different things. As well, you have many merged cells in your sheet and merged cells most often also cause problems for Excel. Would it not be just as easy to simply click in the column you want and enter your data? Is there a reason why you want a macro to do this?

Originally Posted by Mumps1

At the moment, the macro hides/unhides certain rows if you choose "Promotion" or "Acting Up Allowance". Unfortunately, we can't have the macro do something else if "Promotion" is chosen because that would confuse Excel. It wouldn't know what to do because you are asking it to do two different things. As well, you have many merged cells in your sheet and merged cells most often also cause problems for Excel. Would it not be just as easy to simply click in the column you want and enter your data? Is there a reason why you want a macro to do this?

the reason why I like to do this is because I can ensure they complete all the required column.

Do you mean that you want to make sure that the pink cells are completed every time the reason for a change is selected in cell C17?

[QUOTE=excelyee;3130065]Hi, sorry to be a pain, wander if u could help, is there a code I could use for example if they reply to no then macro tell them to move to the right questions or columns[/QUO

Thanks for the advise, I have another questions, when I use the name manager in excel, if I use name like TS1 it will not let me as its conflict with excel built in name, is there anany way I can override this? Thank you so much

Originally Posted by Mumps1

Do you mean that you want to make sure that the pink cells are completed every time the reason for a change is selected in cell C17?

Thanks for the advise, I have another questions, when I use the name manager in excel, if I use name like TS1 it will not let me as its conflict with excel built in name, is there anany way I can override this? Thank you so much

Maybe you could try a different name.

Originally Posted by Mumps1

Maybe you could try a different name.

I need to use the same name? Is this possible thx

To be honest with you, I'm not really sure.