ExcelBanter - Input Box

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

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

- - Input Box (https://www.excelbanter.com/excel-programming/320953-input-box.html)

Avner Mediouni

Input Box

Dear Sirs,
I would like to build a macro that ask the user to input a range using the
mouse (similar to the standard input to the graph dialog).

Can anybody suggest away to to it?

Sincerely

Avner

Bob Phillips[_7_]

Input Box

Use Application.Inputbox, with Type:=8

Set myRange = Application.Inputbox("select a range",Type:=8)

--
HTH

Bob Phillips

"Avner Mediouni" wrote in message
...
Dear Sirs,
I would like to build a macro that ask the user to input a range using the
mouse (similar to the standard input to the graph dialog).

Can anybody suggest away to to it?

Sincerely

Avner

All times are GMT +1. The time now is 05:43 PM.