Hi David,
The information in HELP is fairly decent as to the format.
Also see my page
InputBox, MsgBox and TextBox
http://www.mvps.org/dmcritchie/excel/inputbox.htm

for the third parameter use activecell.formula
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David494" wrote in message
...

Hey

I'm quite new to this VBAing in Access and I'm having a bit of a
problem here.

I have coding which allows an input box to appear when a button is
pressed......

Dim varInput As String

varInput = InputBox("Select your cell?")


First I would like the user to click on a cell to populate the formula
bar with the text they want to search for. Then they click on the
button and the input box pops up. However I want the input box to be
populated with the text from the formula bar.

Is this at all possible?

Cheers

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391278