View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Other option of InputBox for range selection

It is an extra form control.

On the form toolbox, right-click and select more controls, and scroll down
and pick RefEDit from that list.

Drag it onto your form and play with it. It will look familiar, you will see
it in many Excel dialogs.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"yogee" wrote in message
...
Thanks Patrick,
But I don't know about RefEdit control. Will you please tell about that.
Thanks again,
-Rajput Yogendrasinh

"Patrick Molloy" wrote:

how about your button shows a userform. your userform has one control, a
RefEdit control