userform

  1. A

    UserForm for Selecting Workbook Worksheet and Macro

    I'd like to put together a userform so that I can choose from dropdown menus the workbook, the worksheet and a macro. I have a number of macros that are used for modifying certain reports and would like to be able to run the macro based on selecting 1 workbook then 1 worksheet then 1 macro so...
  2. N

    Releasing memory while adding new images

    Maybe a silly topic, but I'm still novice and quite unsure about some details. I have a Userform. Left side column has the menu, consisting of 7 options/"buttons". Those buttons are actually images which change when their area is hovered. E.g. they are originally blue, the hovered state is...
  3. N

    How to call a button sub in a userform, from a module

    I would like to simulate a userform button click from within a module in VBA, but I don't know if this is possible. I tried calling the button click sub from the userform and I am getting invalid procedure. Can someone please let me know if this is possible? Thanks in advance.
  4. L

    Userform display a message when vlookup does not found matching data or does not return a match.

    Guys i keep getting error when textbox value didn't find any value on a range, anyone knows how fix this. Private sub textbox1_AfterUpdate() If textbox1.value = Worksheetfunction.Vlookup(textbox1,Sheet1.Range("A:A") , 1, False) then Msgbox "Data Found" Else Msgbox "No Data Found" End if End sub
  5. L

    Userform display a message when vlookup does not find data in textbox or does not return a match

    Private sub textbox1_AfterUpdate() If textbox1.value = Worksheetfunction.Vlookup(textbox1,Sheet1.Range("A:A") , 1, False) then Msgbox "Data Found" Else Msgbox "No Data Found" End if End sub
  6. S

    Need help changing the Label Caption in Userform

    Hello Everyone, I am looking for a solution to change the caption of a label based on two combo box values. I have two combo boxes with names defined as Year & Month and one label as lbl1. My condition would be if Year.Value = "" or Month.Value ="" then lbl1.Caption = "" Else lbl1.Caption =...
  7. P

    UserForm to and run VBA - unable to find answer

    I have a weekly schedule which I duplicate often. I have Frankensteined a vba (from too many sources to list) that duplicates the first worksheet, names the sheet, and inserts the date. I get information for the variables from 3 InputBoxs. To simplify this I wanted to create a UserForm that has...
  8. R

    Combobox - named ranges and criteria - VBA

    Hi, I have a macro button to open a userform mailing list (see image) which includes a combobox and listboxes. I had written code which got enhanced by member 'beyond Excel' below. Credits to him/her. The goal is to save the Sender, CC and Recipient addresses in named ranges on the data sheet...
  9. Jaafar Tribak

    Grouping UserForms [Having userforms follow each other when moved around the screen]

    Hi, This is a vba code that hopefully accomplishes what the title of the thread says. Obviously, the forms must be modeless so that the user can freely move from one form to aanother. Problem is, using modeless forms makes this task difficult as we cannot subclass modeless forms to properly...
  10. D

    Userform/VBA Image on Top (with most recent Excel)

    Hello all! I hope you're having a great day. What I would like to do is create a simple VBA ("Timer") that just calls a userform and then puts said userform on a timer with Application.OnTime, which I already have. The UserForm ("Bob") is just an image with a text box, not complicated. I want...
  11. D

    Incorporating a Userform into a Sub

    Hi there, I've new to VBA and I've put together a script that allows users select the sheets that they want to copy over from various files in a folder: 1) Select the folders that contains the files that contains the sheets that they are looking to move 2) There will be a pop-up user form that...
  12. R

    Userform listbox search button

    Hi, I have a search button in a userform to highlight/select the matching list item based on the value entered in an inputbox that is activated by this search button. I would like to be able to select the list item, regardless of case sensitivity. With the code below my entered value does not...
  13. N

    MouseMove

    Hello everybody. Pretty silly userform case study, to experiment, yet I'm facing a problem. The UserForm has 2 rectangle images, each in blue color (initially) and green color (when the MouseMove-s on it). When the MouseMove-s over the rest of the userform surface, the images are blue again...
  14. A

    Userform exit while code is running

    Hello all, I have a userform that will automatically close after a set amount of time. My challenge is, that using application.Wait doesn't allow the user to click on a command button to intervene. In this case the command button just closes the workbook immediately instead of waiting. Is...
  15. R

    Error message in userform if duplicate entry

    Hi, I have a data list and a userform to add additional row(s) with data. I would like an error message to pop up whenever duplicate data is entered in the according userform field on the basis of a specific column in a named table. A blank entry field is admitted, but no duplicate entries. I...
  16. N

    VBA - Userform & Image size issue

    Hello everybody, I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel. And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190) Now, one would...
  17. W

    UserForm with multi select : How can I submit the form and send the data into a column?

    So I made a userform (picture above). This works so that I can add people from listbox1 to listbox2. That part is working. But what I want to do is make it so that when you click submit all the names in listbox2. populate column A from A2 down (under my headers). This si the part I am confused by.
  18. J

    Make a filter to all columns in a listbox

    I want to make a filter to show in a listbox all the coincidences with the text write in a textbox. and set focus in the coincidence. How can i do it? Here is my file LINK TO FILE Thanks for youre help
  19. R

    Userform to fill first empty row in named table

    Hi, I have a userform with text fields and checkboxes. The data entered in the userform will be transfered to a new row in the named table "tblColleagues". This table already contains a few rows with data but the named table range also covers lots of empty rows. How is it possible to make the...
  20. A

    Command Button press to put data in UserForm to specific cell

    Hi there, I have a VBA Userform, when the command button is pressed the data inserted into the UserForm needs to be placed in specific cells within the workbook. Sheet name - Sheet3 (Template) Textbox1 to B5 and C59 Textbox2 to D59 Textbox3 to C62 Textbox4 to D62 Textbox5 to D7 Textbox6 to F7...

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