Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically Hiding portions of a UserForm
I have a user form with 12 frames, each representing a "row." The user form gets the total number of rows (a number between 1 and 12). Each frame is named "Row?Frame", where the question mark is a number between 1 and 12. The user form is named DefineRowsUserForm. I want to hide all the rows that are not needed. For example, to hide row 3: DefineRowsUserForm.Row3Frame I want to automate this to hide the uneeded rows based on the total number of rows. I tried to do this as follows: Dim RowEraseLabel As String 'Get the number of rows NumRows = Val(ConnUserForm.NumPinsTextBox.Value) 'Hide unnecessary rows For i = NumRows + 1 To 12 Step 1 'count over pins in each row RowEraseLabel = "DefineRowsUserForm.Row" & i & "Frame" RowEraseLabel.Visible = False Next i The above code does not work, but only shows the idea of what I want to do. If anyone knows a slick way to do this, please help. -- fly_fish_boy ------------------------------------------------------------------------ fly_fish_boy's Profile: http://www.excelforum.com/member.php...o&userid=32456 View this thread: http://www.excelforum.com/showthread...hreadid=522292 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically create userform | Excel Programming | |||
Problem with Blocking Dynamically generated UserForm Call | Excel Programming | |||
How can I create and display a chart dynamically on a UserForm wi. | Charts and Charting in Excel | |||
dynamically create userform | Excel Programming | |||
How to create labels in a UserForm dynamically and be able to resize them with the mouse. | Excel Programming |