+ Reply to Thread
Results 1 to 7 of 7

Clear textbox of combobox after every selection

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    404

    Clear textbox of combobox after every selection

    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

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,130

    Re: Clear textbox of combobox after every selection

    try:

    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    404

    Re: Clear textbox of combobox after every selection

    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

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,130

    Re: Clear textbox of combobox after every selection

    Please attach your workbbook

    UploadWorkbooks.jpg

  5. #5
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    404

    Re: Clear textbox of combobox after every selection

    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

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,130

    Re: Clear textbox of combobox after every selection

    This works:
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    404

    Re: Clear textbox of combobox after every selection

    Thank you so much Dear Expert Kev_ it worked perfectly.

    Many thanks and kind regards,

    Neilesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1