userform initialize

  1. P

    Userform initialize (sometimes works, sometimes don't!)

    Hello all, I have a workbook saved as Excel Macro-Enabled Template and sometimes when I open the file, after the userform is initialize, the rules for the textbox aren't available (the vba tab order and the limitation in writing only numbers). If I press tab is adding space in the cell, also...
  2. M

    Userform_Initialize() Dim Range prevents userform from opening on other worksheets

    I'm creating a userform (SOP421) that will serve as a "quiz builder"; i.e. the label captions and option button captions are pulled from specific cells in Sheet3("TRAINING") so that the questions and available answers can be modified from within the worksheet. Initially, I got the form working...
  3. Prevost

    Combobox lists from public range variable

    Hi Everybody. I am trying to call a public range to use as the data source for my combobox drop down list, however I continue to receive errors. I found some code that worked by declaring the range variable within the UserFrom_Initilialize() but I can't seem to transfer it over to what I would...
    • Prevost
    • Thread
    • combobox populate public range variable userform initialize
    • Replies: 7
    • Forum: Excel Questions
  4. T

    Initialize UserForm after selecting from List

    I have an Excel Workbook, in which I have a dropdown list. I would like a userform to initialize if certain choices are selected from the list. Is this possible? And if so any help with code would be great. Thank you.
  5. N

    VBA Error Message Run-Time Error 1004

    I have written vba script but keep getting this error message: Run-Time error '1004': Method 'Ranger' of Object'_Worksheet' Failed. Can anyone tell me what's wrong with this code: Private Sub UserForm_Initialize() Dim Site As Range Dim Location As Range Dim Printer_Type As Range Dim ws As...
  6. B

    vba Useform Initialize/Open

    Sorry had a brainstorm and figured it out, you have to paste the Private Sub within the Userform Code, not a module.

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