dynamic userform

  1. P

    Update userform controls stored in model via VBA

    Hi I've not been able to find anything on this via Google, so I'm posted a question on it here in search of some help. I'm not very conversant with using VBA on userforms so please bare with me if this is something trivial. I have set up a userform with a set of text labels, some for column...
  2. J

    Adding Mutiple Lines of Textboxes / Combo Boxes

    Hi All, I am currently putting together a stop-gap time booking tool. I am using a userform for this. Users will be able to add new lines, consisting of time entries for each day, against booking codes. The number of lines needs to be dynamic. The user presses a command button to add a new...
  3. B

    Dynamic Userform to delete selected sheets

    I want to create a userform that will list all worksheets in a workbook with CheckBoxes next to each one. The user then can check the worksheets they wish to delete, and click the OK button to delete them. I have been able to create a userform that lists all the sheets, but that is about it. Any...
  4. B

    Dynamically updating userform that lists worksheets and allows to edit one cell in each worksheet

    OK, I have a question that I am stuck on. I would like to allow users to display a userform that lists all worksheets except for three (Sheet 1, Sheet 2, Sheet 3) in the workbook and has a textbox next to the worksheet name that displays the value of cell A1 in that particular worksheet. The...
  5. V

    Runtime error 50289

    Hi, I am trying to generate a dynamic user-form via vb code. I have protected the code module using VBA Project Properties. But when I re-open the workbook and run the code, I am getting the "Runtime error - '50289' - Application defined or Object defined error.". When I tried putting some...
  6. V

    ComboBox AddItem Issue

    Hi, I am creating a dynamic UserForm in which i am creating a ComboBox. I want to populate the ComboBox dropdown with names of the sheets present in the workbook. UserForm is created successfully but ComboBox dropdown is always blank. Here is the code: Set NewComboBox =...
  7. V

    Runtime Error 1004 in dynamic UserForm

    Hi all, I am using a code available on one of the sites for creating a dynamic user form. but i am not able to proceed at all because of Runtime Error 1004 "Application Defined or Object Defined error". here is the part where i am getting it: Sub MakeUserForm() Dim TempForm As Object...
  8. ghelfer

    Dynamic userform.images

    I have a lot of images on userform2 and I need to access its in userform1.image1 as below: for x = 1 to 150 if range("A" & x) = 1 userform1.image1.picture = userform2.image[x].picture end if next x I spent a lot of time finding o solution for this but I am desting...
  9. craig.penny

    Programmatically remove a control from userform

    Greetings, Suppose I have a userform named myUserForm and a checkbox on it named myCheckBox. How on earth do I remove myCheckBox from myUserForm at run time? I've tried every which way I can think and I always get "error 444". Some things I've tried are: myUserForm.Controls.Remove...

Some videos you may like

This Week's Hot Topics

Top