hi, everone
i am passing my data using textbox to sheet using userform.
is it possible to before passing data to sheet it change the value of textbox,
like, i type "EF" in textbox so it change to "Excel Forum". its like we assign a shortcut using File>Option>Proofing>AutocorrectOption>Auto Correct
or i type "HS" it will change to "HaroonSid"
thanx
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
It probably can be done but there has to be a list somewhere containing the values that need to be replaced and the replacement value.
Or maybe two arrays in the code which we loop too look for one value and then retrieve other value from second array.
Maybe an example file will help.
Last edited by bakerman2; 02-10-2017 at 04:36 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
try to have a database that lists all possible entries with it's corresponding value on another sheet. It's gonna be easier that way.
ok, i will make all possible entries list, after making this who to i use this database
Example file is here
Capture.JPG
Where's the list ????
list added to my textbox1, which value i want to change
Please Login or Register to view this content.
Above solved my problem
no need further solution
thanx a lot for reply bakerman2
Take a look at this.
Please Login or Register to view this content.
Yes,
this i it what i want
thanx bakerman2
thread solved
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks