John_McClane
New Member
- Joined
- Apr 30, 2013
- Messages
- 27
Hi Guys,
I've been searching around for a few days but can't seem to find what I am looking for.
I've created a worksheet with several drop down lists that are INDIRECTly related to eachother. As there are several hundred options in each list, I would like the user to be able to start typing what they want inputted rather than looking through hundreds of options (AUTOFILL). However, as my options are based upon labelled ranges, they have underscores instead of spaces, so when you type if it hasn't auto-filled before the end of the first word, it won't find it.
So, I'm not sure if it's possible but is there anyway you can set autocorrect to replace a space with an underscore as you type? Or, assign _ to the space button? Or even a code or macro?
I'm familiar with SUBSTITUTE and have used it but it's not really what I'm looking for as it will only change it AFTER it has been inputted.
Thank you
I've been searching around for a few days but can't seem to find what I am looking for.
I've created a worksheet with several drop down lists that are INDIRECTly related to eachother. As there are several hundred options in each list, I would like the user to be able to start typing what they want inputted rather than looking through hundreds of options (AUTOFILL). However, as my options are based upon labelled ranges, they have underscores instead of spaces, so when you type if it hasn't auto-filled before the end of the first word, it won't find it.
So, I'm not sure if it's possible but is there anyway you can set autocorrect to replace a space with an underscore as you type? Or, assign _ to the space button? Or even a code or macro?
I'm familiar with SUBSTITUTE and have used it but it's not really what I'm looking for as it will only change it AFTER it has been inputted.
Thank you
