Control for a Form

  • Thread starter Thread starter Raul
  • Start date Start date
R

Raul

I'm looking for a control to allow a user to select a
range of cells while in a form. I'd like to use a
control that looks like the one used in the chart wizard
to select the data range. Can anyone help me out?

Thanks,
Raul
 
Try the RefEdit control. It may not be on the Toolbox, but if you right
click on the ToolBox and select Additional Controls, you can scroll down and
select the RefEdit control and it will then be on your Toolbox. Refer to
the Excel VBA help for control use.

HTH.

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
 
Thanks Michael. This is what I was looking for.

I really appreciate it.
raul
 
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

Need a control to pick worksheet cell ranges 2
VBA set thick borders around non empty cells in range 0
Access Form Refresh 1
"De"-select a forms control programmatically 4
Chartspace & Excel2003 0
deselect any "active" charts in workbook 2
Dynamic chart problem 1
Calculate the number of Columns apart 2

Back
Top