Default data in an input box

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
 
M

merjet

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
Input box display 2
Cancel Input Box error 16
VB Code Question - Input Box 2
Input Box Location 8

Top