userfom

Hi I made add in in vba that include form.I want that the form retrieve cell content into textbox of the form if the user press on column B in the workbook. So, I worte the sub Workbook_SheetSelectionChange inside ThisWorkbook but after I saved my worksheet as .xlam file the sub...

Hi Guys, I have a feeling this will be incredibly simple and I am just unable to put the right search terms together to find my answer. I currently have a workbook with 1 sheet and several VBA buttons that open different Userform. Then we enter information and hit save to save in a particular...

Hi, I have built an excel user form which captures data. I have a combobox called 'ClosedCB' with the options 'yes' and 'no'. If the value in ClosedCB is 'no' I would like it to clear another textbox called 'ReviewTB'. Here is my code so far... Private Sub SaveBTN_Click() If...

I have a userform with a series of Comboboxs. The idea is when you change the combobox "ztype" it changes the comboboxs "zamps", in every case but one. When " ztype" is Awning Lighting then amps is 1 When " ztype" is 27in Channel Letters then zamps is 2 When " ztype" is 36in Channel Letters...

Hi there, I have a userform to add and update a project database. The database is around 200 columns long (project info) by about 200 rows deep (individual projects). I have a userform to help enter in the project data that then updates the "master database" sheet when a command button is...

Morning all, I'm looking for help getting an idea from my head into a VBA code, I am very new to this!! I have a spreadsheet that I have a column (column E) that is populated with a unique number by a barcode reader. I am trying to get a command button to open a UserForm where the unique...

I have a userform, and i applied the following in order to run the userform without showing the sheet <code style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px...

Guys, I wonder if anyone can help...I have created this code from snippets and my own knowledge to add the information in a userform to a spreadsheet, simple columns etc... I would like to know: If there was a quicker and more efficient way of completing what has been done in the routine...

im working on a userform that updatas the data if the person fist and last name is in on the sheet in column B&C. so what i would like to do is if the frist and last name match then it updates the row with textbox3,textbox4 ...ect then it textbox5 adds the "new info" the frist blank column...

Hey Everyone, I am trying to create Minesweeper in excel (to increase office productivity). I am already pretty good with VBA so creating it in a worksheet would be a cakewalk for me, so I am trying to create it in a user form.I also want to learn how to get better with class modules, which...

Hello, with some book help, I wrote this code:Sub Data() Dim dtime As Date Dim Ans As Integer Ans = MsgBox("Have you transfered the data today?", vbYesNoCancel) If Ans = vbYes Then MsgBox ("Ok, Keep Your Work") ElseIf Ans = vbCancel Then Exit Sub...

Hi Guys! My question is very short but I couldn't solve it. I have a Johnjpg1 image in Form1. And at the end of my worksheet Sub Module it shows Form2. If A1="John 01" Then Display From1\Johnjpg1 in Form2\Frame1 Thanks a lot!