VB Question

G

Gav Dent

Is there anyway of writing a macro which when run will give the user a
message box for them to enter some data and then put this in an appropriate
cell on the spreadsheet?

TIA
 
F

Frank Kabel

Hi Gav
to give you an idea:
Sub test_input()
ActiveSheet.Range("D1") = InputBox("Enter your value")
End Sub
wil put the value entered via the inputbox in cell D1 of the active
worksheet
 
Top