userform

Hi All, Ive searched and searched and cant find an answer to my query. If it has been answered already please point me in the right direction. I have a shared excel workbook where multiple staff could be in at the same time. Staff input and update data via a userform. To populate the excel...

Hey Guys, i have an Workbook with 5 Sheets where you can add Data while Using a Userform. The Data begins in each Sheet in row 10, since i nead the rows above 10 for my interface. I have also an Mastersheet, where the Data from these specific Sheets should be copied and should be edited if...

Hello all! I have been reading posts here and online and i'm not sure which path to try. I have a Userform with many buttons that lead to various "Orderforms" - 1 per vendor. What my macro does is capture the info from each vendor onto 1 "Summary" Sheet and 1 "customer info" sheet. (I guess...

Hello, I'm very new to VBA and I'm trying to work through a project but have gotten stuck. I'm trying to have a comment entered into cell I13 and then any subsequent comments to be entered in the row below and so on. So far this is what I have, but it stops working after the second comment has...

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