98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Input Box query
Input Box query
Resolved · Urgent Priority · Version 2010
Adrian has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Input Box query
I'm working on a macro to automate a process within excel.
Part of the macro involves the user selecting a sheet (idmap). Then selecting column B . Then I've added an input box for the user to enter an id number. After this step I want this number in column B to be selected on the sheet and a '1' entered 2 columns to the right (column D) of this id number. I've added some of the code so you can get a better idea of what I am trying to achieve.
Sheets("idmap").Select
Range("D2:D5000").ClearContents
intorg_id = InputBox("Enter the org_id")
Cells.Find(What:="intorg_id", LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Activate
Regards
Adrian
RE: Input Box query
Hi Adrian
I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.
Thank you for your patience.
Kind regards,
Andrew
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |