Hi all,
I've got a userform with a combobox. I would like to remove the last character of some selected items from the combobox list. However, when I use the backspace key, the last character is highligted in blue. I have to use the delete key in order to have it removed.
What can I do to allow the backspace key to be used?
Thanks,
BDB
Hello BDB,
You need to use the TextBox_Keypress event to detect the backspace. Here is the code. Change the name of the Text Box to match what you are using.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
With the code you provided, I sat it up for a combobox. After doing that, I have not yet
been able to get to function. Using the backspace key is still just highlighting the last character and each consecutive last character with each key press.
Any other suggestions?
Hello BDB,
For the quickest turnaround, you should the workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks