Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Input Box query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Input Box query

Resolved · Urgent Priority · Version 2010

Reply Tue 25 Jan 2011, 17:10Delegate Adrian said...

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

For upcoming training course dates see: Pricing & availability

Reply Mon 31 Jan 2011, 10:38Trainer Andrew said...

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

Excel articles

· Compare Different MS Excel Training Methods
· What Do The Formula Error Messages Mean In Excel?
· How To Create A Multiple Pie Chart In Excel
· How To Get The Best Out Of Excel With The Internet
· Tips To Help You Excel

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips