I have a drop-down with the following items:
New
Uniform
Uni. Instr.
Instructor
Assist.
Old
The following partial code works for all selections except "Uni. Instr." ie If line 10 is If CelChosen = "Uni. Instr." then. Please tell me where I'm going wrong, (relative newbie to macros)
Please Login or Register to view this content.
Make sure the Target cell value is exactly "Uni. Instr."
The caps have to be the same and there is no trailing space character in the dropdown.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
All checked and correct but not working, I'm tearing my hair out.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
@AlphaFrog
Thanks for your input. It's now working. Your confirmation tha it should work made me dig a bit deeper. A previous And/Or line of code (although it appeared to work) was incorrectly constructed causing the sub to exit when "Uni. Instr." was chosen from the dropdown. This is my first attempt at a rather complicated macro programming excercise and have spent hours searching the web finding out how to do things - it's all a (rather steep) learning curve.
Glad you figured it out. Well done and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks