Posted to microsoft.public.excel.programming

Stan

external usenet poster

Posts: 150

VB Code Question - Input Box

I'm trying to use an input box to add some data to cell N4 although after
entering the value in the input box, the cell is still blank. Can someone
help out a rookie code writer? Many thanks!

Sub FixMissingData()

Range("M4:O4").Select
Selection.Insert Shift:=xlDown
Range("M4").Select
ActiveCell.FormulaR1C1 = "Overtime"
Range("N4").Select
InputBox ("Enter Overtime")

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pause code, wait for input, no input received, carry on with the code	[email protected]	Excel Programming	1	September 29th 05 12:19 PM
Input Box Question with Code	K Dales	Excel Programming	0	August 16th 04 07:45 PM
Input Box Question with Code	sebastienm	Excel Programming	0	August 16th 04 07:37 PM
Input Box Question with Code	Tom Ogilvy	Excel Programming	0	August 16th 04 07:34 PM
Input Box Question with Code	Bob Phillips[_6_]	Excel Programming	0	August 16th 04 07:29 PM

All times are GMT +1. The time now is 04:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us