userform

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...

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...

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.

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

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

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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

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...

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...