Thread: How do you do a range selection dialog like those many in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
John Bundy John Bundy is offline
external usenet poster
  
Posts: 772
Default How do you do a range selection dialog like those many in Excel?
There is a RefEdit control for the toolbar, add it if you don't have it
already by selecting More Controls (hammer and wrench icon) and select
RefEdit. You need to have a userform up to do this in VB, right click on your
project and add Userform, the toolbox will appear.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LunaMoon" wrote:

Hi all,

I want to select some range dynamically, including multiple selection,
via showing a range selection dialog...

Hopefully there are some dialog functions that I can use...

How to do that in VBA?

Thanks!

Reply With QuoteReply With Quote