How to use MS assistant instead of drop down list in excel

[johngryn]

I would like to use MS Office assistant in Excel instead of a drop down list.
I know when you turn assistant on and off (to often) you get a selection
ballon as to weather of not you want to close or keep using it. And Inputing
a range of cells in the Alerts I've done. But HOW do you get a selectable
range like the one in the "Do you want to keep assistant open or hide or turn
off" Baloon. Do I have to learn some programing or is something out there
that does that?

John Gryn

 

[Gord Dibben]

Not sure from your description what you are looking to do.

Do you want to be able to select a range of cells and use that range for
something?

Sub selectit()
Set rngtouse = Application.InputBox(prompt:= _
"Select A Range", Type:=8)
MsgBox "range is " & rngtouse.Address
End Sub


Gord Dibben MS Excel MVP