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

  • Thread starter Thread starter johngryn
  • Start date Start date
J

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA assistance 4
Data validation drop down list selection change 4
EXCEL DROP DOWN 2
Pick from drop-down list gives empty or erroneous result 6
Set Column choice to a variable from a Drop Down 4
Drop down-list translation 2
Link Drop Down list with PIVOT Table in Excel 2003 0
Assistance with VBA and drop down list 0

Back
Top