For data entry with complex validation, a userform is indeed preferable.
But if you want tojust want to add a few check boxes or option buttons to a worksheet, without needing VBA code, controls from the Forms toolbar are very handy.
And a scroll bar on top of a chart can be a good way to let the user modify chart parameters.
F3 function key in maintaining Controls (Excel 2000)
-
- Administrator
- Posts: 78510
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: F3 function key in maintaining Controls (Excel 2000)
Best wishes,
Hans
Hans
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: F3 function key in maintaining Controls (Excel 2000)
Hi Chris,
I see. Well, as Hans said already: if the data entry is complex, a userform may be the best way to handle it.
I see. Well, as Hans said already: if the data entry is complex, a userform may be the best way to handle it.
-
- PlutoniumLounger
- Posts: 15633
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: F3 function key in maintaining Controls (Excel 2000)
(but not as good as the last 13 videos here, eh?HansV wrote:And a scroll bar on top of a chart can be a good way to let the user modify chart parameters.
There's nothing heavier than an empty water bottle
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: F3 function key in maintaining Controls (Excel 2000)
Here here! I find the activeX control toolbox controls a nightmare to work with. I much prefer the Forms toolbar.Jan Karel Pieterse wrote:Hi Chris,
As Hans said, I was referring to the controls you can put on your worksheet, which are devided in two camps: the form controls and the control toolbox controls, AKA ActiveX controls. The Form controls have my preference.
Nathan
There's no place like home.....
There's no place like home.....