View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Incidental Incidental is offline
external usenet poster
 
Posts: 226
Default Prompt user to select a range

Hi Aaron

You could use the refedit control, it should work for what your
after. To use it you will need to add it to your toolbox you can do
this by right clicking the userform toolbox selecting additional
controls and then finding RefEdit.Ctrl and checking it. Then select
the tool and place it on your userform, it works just like the goal
seek selection method.

Hope this helps

Steve