in the following code what i want is that if textbox has CTF in it then whatever value appears in tb1 shuld goto the range("CTF"). I have already been able to achieve this, but when person writes `st whatever value appears in tb1 should goto range("ST") and it does......but when i enter `st it also updates the same value in range("CTF"), can you please help
Please Login or Register to view this content.
Suggest you post a sample workbook so the code can be seen in context.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Look on your Formulas Tab and then at your Names Manager. See where the Named Range of "CTF" is located.
Is that the problem?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks