Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

input box query

ResolvedVersion 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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.