Clear textbox of combobox after every selection

[Neilesh Kumar]

Dear Experts,

I am using the codes for go to specific worksheet via combobox, is as below:

Please Login or Register  to view this content.

I am looking for the textbox selection to be clear after every selection made and textbox to be clear too before close workbook and when workbook open. The combobox List fill range is in worksheet "Set-up" from cell I23:I47 and the Linked Cell is in Worksheet "Set-up" at cell J23.

Your precious support would highly be appreciated.

Regards,

Neilesh

[kev_]

try:

Please Login or Register  to view this content.

[Neilesh Kumar]

Dear Expert Kev_ thank you for your valuable support but the provided codes is getting debug at ComboBox1.Text="". Request to you please look into the same.

Many thanks and kind regards,

Neilesh

[kev_]

Please attach your workbbook

UploadWorkbooks.jpg

[Neilesh Kumar]

Dear Expert kev_ Please find here attached sample workbook where the provided code is getting debug. Request to you please do help me out.

Many thank and kind regards,

NeileshSample workbook for Combobox text clear.xlsb

[kev_]

This works:

Please Login or Register  to view this content.

[Neilesh Kumar]

Thank you so much Dear Expert Kev_ it worked perfectly.

Many thanks and kind regards,

Neilesh