userform

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

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...

I have an userform that users toggle buttons to that will make text boxes appear if toggled but I have issues passing the date if two toggle boxes are pressed for example toggle box1 = true then 2 text boxes will appear where users will put data in toggle box2= true then 2 text boxes will...

I am creating a userform for my organization which has multipage controls on it, and many controls within each multipage. I had been working on getting the userform completed until I ran into an "Out of memory" error. This happens on a fresh restart of my computer and with no other programs...