ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   controls on worksheet (https://www.excelbanter.com/excel-programming/290761-controls-worksheet.html)

jim c.

controls on worksheet
 
i have forms 2.0 frame control with some textboxes in it
embedded on worksheet. The tabbing through the controls
works fine. On another sheet I have forms2.0 multipage
control. I cannot tab through the textboxes!? This is
strange. I have a lot of experience with userforms, but
this is the firs time I've worked with controls on a
worksheet. Is there something I'm missing? I've already
checked the properties and everything is as it should
be... I think... lol

Tom Ogilvy

controls on worksheet
 
Multipage controls on worksheets are not really supported. Notice that you
could not select it from the control toolbox toolbar, but had to go looking
for it in more controls.

--
Regards,
Tom Ogilvy

"jim c." wrote in message
...
i have forms 2.0 frame control with some textboxes in it
embedded on worksheet. The tabbing through the controls
works fine. On another sheet I have forms2.0 multipage
control. I cannot tab through the textboxes!? This is
strange. I have a lot of experience with userforms, but
this is the firs time I've worked with controls on a
worksheet. Is there something I'm missing? I've already
checked the properties and everything is as it should
be... I think... lol




jim c.

controls on worksheet
 
I'm getting ready to upgrade to excel2003, any hope it
might be supported there? TIA

-----Original Message-----
Multipage controls on worksheets are not really

supported. Notice that you
could not select it from the control toolbox toolbar, but

had to go looking
for it in more controls.

--
Regards,
Tom Ogilvy

"jim c." wrote in

message
...
i have forms 2.0 frame control with some textboxes in it
embedded on worksheet. The tabbing through the controls
works fine. On another sheet I have forms2.0 multipage
control. I cannot tab through the textboxes!? This is
strange. I have a lot of experience with userforms, but
this is the firs time I've worked with controls on a
worksheet. Is there something I'm missing? I've already
checked the properties and everything is as it should
be... I think... lol



.


Tom Ogilvy

controls on worksheet
 
I suspect it was a conscious decision on Microsoft's part, so I wouldn't
expect a change unless it was in high demand. If I had 2003 installed, I
would check it - but I don't. Maybe someone else can give you the
definitive answer.

--
Regards,
Tom Ogilvy
"jim c." wrote in message
...
I'm getting ready to upgrade to excel2003, any hope it
might be supported there? TIA

-----Original Message-----
Multipage controls on worksheets are not really

supported. Notice that you
could not select it from the control toolbox toolbar, but

had to go looking
for it in more controls.

--
Regards,
Tom Ogilvy

"jim c." wrote in

message
...
i have forms 2.0 frame control with some textboxes in it
embedded on worksheet. The tabbing through the controls
works fine. On another sheet I have forms2.0 multipage
control. I cannot tab through the textboxes!? This is
strange. I have a lot of experience with userforms, but
this is the firs time I've worked with controls on a
worksheet. Is there something I'm missing? I've already
checked the properties and everything is as it should
be... I think... lol



.





All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com