textbox only visible after clicking cell

[milo1984]

Hi

I am experiencing what is most likely a simple error. the below only works after a click in any cell to effectively bring it to life. what do I need to add to get it to do this automatically?

Please Login or Register  to view this content.

Many thanks in advance

[Arkadi]

You mean you have to trigger the worksheet change before the textbox becomes visible? Most likely it was saved in an invisible state? You could add a workbook open event and put the same code in there, so that each time the workbook is opened, the textbox will be visible if V10 = "Default".

[milo1984]

Hi, many thanks for your response.

yes and no. V10 is a linked cell to a combo box. so based on the outcome of the combo box, the textbox will appear or not.

sorry, not sure what you mean by the 'invisible state'.

Best regards

[Arkadi]

Oh.... I see, so when you change the combobox to "Default", nothing happens until you click on a cell?

[Arkadi]

can you provide the workbook? (no data required, just the combobox and code)

[milo1984]

I have attached a workbook.

As you will see, if you click in any cell after changing from 'Default' to 'Other', the textbox will appear / disappear...but not automatically.

Many thanks

[Arkadi]

When a sheet changes via VBA, the change event does not trigger.... replace your worksheet change event with a new sub:

Please Login or Register  to view this content.

This will trigger when the combobox changes, so it will work as you want I believe.

[milo1984]

perfect, thanks for your help.

[Arkadi]

Happy to help milo!

Please remember to mark the thread as solved if the issue is dealt with to your satisfaction.