Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add controls on the fly/dynamically
Hi All. I use this code to rename the tabs of multipage control on a userform. Sub page() For Each Cell In Sheets("Data").Range("major_streams") frm_daily_entry.MultiPage1.Pages.Add Cell.Text Next End Sub The problem I have is that when creating the tabs on the fly I also have to create other controls on the fly too, specifically Labels & textboxes. The Labels & Textboxes will be defined by looking up the caption of the current tab (on sheet1) and adding however many label/Textboxes that are required (one for every item under the heading on the sheet). Anyone have any ideas? thanks Kevin -- jinx_uk_98 ------------------------------------------------------------------------ jinx_uk_98's Profile: http://www.excelforum.com/member.php...o&userid=28878 View this thread: http://www.excelforum.com/showthread...hreadid=486908 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to group parts with controls? | Excel Discussion (Misc queries) | |||
Select All controls in a worksheet and delete them | Excel Discussion (Misc queries) | |||
After installing Office XP SP3, Excel ActiveX controls are moved a | Excel Discussion (Misc queries) | |||
Help on Excel controls | Excel Discussion (Misc queries) | |||
ActiveX Controls Display Issue? | Excel Discussion (Misc queries) |