VB Question

  • Thread starter Thread starter Gav Dent
  • Start date Start date
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
 
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
 
Back
Top