I'm in the process of making a training tracker for multiple office sections. I was able to create a data entry form that will send an individual's information to the sheet for their respective section. However, the only solution I could think of to easily update old information without making a...
Hi all,
I have a UserForm that Loads and Shows when the Workbook is opened.
The User is given the current date setting that is saved to a worksheet cell on each use.
Ths User is then given a choice to use a different date Yes or No.
If the User chooses Yes, then a Listbox on the UserForm is...
Hello,
I have a excel workbook that I have created that needs a specific code for userform combobox.
The question/ problem, the combobox has a selection which is automatically populated in the initialization. In combobox the selection is:
1. clamp install
2. damaged clamp
With that...
Hello all
I really need your help as the topic title says I need to find the minimum, maximum, less than 4000 among the selected listbox items.
AB1EmployeeSalary2Gilmore34403Stone67804Horton102445Rice54326McDaniel205447Fowler123228Paul54409Burns765610Robertson4568
I already have a form, but I...
Hi I have a UserForm that has a filter Combobox that filters different criteria. and that includes "Year" and a TextBox which will be the search box. and a listbox that will show result
Note: "Year" is in separate column ("T")
the search box is working fine for other criteria, except for...
Hi all,
I have a number of similarly named user forms that are called based on the value in a cell. I am trying to find a more efficient way to call the user forms without having to add additional elseifs to the code everytime I add a few more. I thought I had the right idea, but perhaps I...
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...
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.