Hello all,
I have a small Vba macro, that doesn't seem to work, because I am very new to vba and can't spot the likely simple error, any help would be much appreciated,
I am looking to enter a character into an input box and a range and then delete all text after and including the character/work in the input box.
Thanks in advance to anyone who wants to help
cheers
Please Login or Register to view this content.
Type:=8 is restricting your Inputbox to a range. That is ok for WorkRng which is expected to be a range, but Crit1 should be a string so change it to Type:=2 (only for Crit1 input box).
Also, you will find you are keeping one character too many. Change the c.Value code to:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks