ExcelBanter - Inputbox to return address of cell selected by mouse

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Inputbox to return address of cell selected by mouse (https://www.excelbanter.com/excel-programming/280583-inputbox-return-address-cell-selected-mouse.html)

D.S.[_2_]

Inputbox to return address of cell selected by mouse

Anyone know how I can use the inputbox so that the value of the inputbox is
determined by the cell I select with my mouse?

D.S.

Donald

Cliff Myers

Inputbox to return address of cell selected by mouse

Target.Cells = InputBox("Cell value is ", "Cell value", ActiveCell)
HTH

"D.S." wrote in message
...
Anyone know how I can use the inputbox so that the value of the inputbox
is
determined by the cell I select with my mouse?

D.S.

Donald

Tom Ogilvy

Inputbox to return address of cell selected by mouse

See Harald's answer to your previous post.

--
Regards,
Tom Ogilvy

D.S. wrote in message
...
Anyone know how I can use the inputbox so that the value of the inputbox
is
determined by the cell I select with my mouse?

D.S.

Donald

All times are GMT +1. The time now is 08:25 AM.