Default data in an input box

  • Thread starter Thread starter jonco
  • Start date Start date
J

jonco

I want to have Excel enter the value of a particular cell as the DEFAULT
entry of an input box. Is this possible?

ActiveCell = InputBox("Note?, Add a Note to Transaction", , (A5))

*In this examplethe value of cell A5 would be the Default data for the input
box.

I'm not sure what the syntax is if it's possible.

Thanks for the help.

Jon
 
Change your last argument to something like
Sheets("Sheet1").Range("A5") and you got it.

Hth,
Merjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Withusing of input box data store in given cell 11
How to validate that input was entered into Input Box 6
input box prompt 1
go to specific cell using drop down box 4
Cancel Input Box error 16
Input box display 2
Remove data from column 4
InputBox entries & advice 16

Back
Top