.top

  1. A

    Select Case Problem

    Please consider this userform initialization code. Private Sub UserForm_Initialize() 'Hide frames F1_WCF.Visible = False F2_WCA.Visible = False F3_WCO.Visible = False F4_CCF.Visible = False F5_CCA.Visible = False F6_CCO.Visible = False F7_PTD.Visible = False...
  2. R

    Userform startup position

    Greetings, I am using the following code to open a number of userforms simultaneously in a cascade layout. The first code (cleanroom zone) runs perfectly and the userforms layout just as I want them to. But the second one (grayroom zone) doesn't. The userforms do not start up in the same...
  3. M

    passing a frame name to a subroutine

    I'm trying to create a subroutine (actually two) The first finds the coordinates of the frame and stores the value, then sets the values I need to explode the frame size. Sub displayframe(frm As msforms.Frame) With frm ht = .Height wdth = .Width Tp = .Top lft = .Left...
  4. H

    textbox exit event on userform

    Hi, i create multiple textboxes with dynamic names during the run time on userform. On any of the textbox exit, i need to do some calculation and show the output in a label corresponding to that particular text box. however the textbox exit event is not working with the dynamic name that i...
  5. P

    Any ideas? UserForm Initialization doing funny things.

    I have a userform that shows or hides different controls based on what is selected from ListBox1. It also adjusts the left and top values of the appropriate controls depending on that selection, just to make everything look good. So upon initialization it sets the left and top values of each...
  6. A

    Help With adding multiple controls during runtime based on button click

    Hello, I would like to see if it is possible to control the addition of Labels and text boxes based on a button click to my multipage object on my form. My initial thought was to use a case statement that would count the button clicks and add the labels and text boxes as needed. However, if I...
  7. V

    Need help understandig why something works in VBA, and something else doesn't

    These work: Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveSheet.CommandButton1 .Top = ActiveWindow.ScrollRow * Rows(ActiveWindow.ScrollRow).Height - 14 End With End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim intCellHeight...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top