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

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

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

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

On Sun, 17 Feb 2008 00:53:00 -0800, johngryn
wrote:

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