Hello all,
I have created a user from that is automatically checking for out of date dates and automatically creating the emails and currently displaying them before being sent. I need to be able to mark the next empty cell as 'Email Sent' to indicate that the email has been sent for that...
Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...
Hello! I have a userform with two sections. There are 4 checkboxes in each section with the idea that they will be pre-populated comments that will fill into a textbox. I am able to get it to populate text into the textbox when one box is checked however the way I have it written only allows for...
Hello!
I have a userform which will be used to complete audits on employee work. There are 2 sections which will be audited with 1 of 3 possible responses (Yes, No, N/A). As the auditor completes the form they are pressing a button (Images - Thumbs Up, Down or N/A) which will populate a text...
I have the below code that works:
Private Sub CommandButton1_Click()
Dim cell As Range
For Each cell In Range("I2:I2")
cell.Formula = Replace(cell.Formula, "100,", TextBox1.Value + ",")
cell.Formula = Replace(cell.Formula, "260000000000,", TextBox2.Value + ",")
Next cell
End Sub
But, I would...
Hi guys
i have a problem about my userform i have 16 textbox and command button to search in textbox 1.
is it possible to search only the last 3 digit number in textbox1 instead of 8?
here is my code for my command button
:):):)
Dim totRows As Long, i As Long
totRows =...
When sending data to a worksheet the record is transferred successfully but the all cells that contain numbers have the green triangle(formula error I am guessing) and cannot be formatted as well as the cells with dates also cannot be formatted. This in turn prohibits those rows to be included...
Hey guys, am a newbie to VBA programming... And at work am developing a userform for the excel spreadsheet.
The spreadsheet tracks the operation of the tractor, its attributes include date, opening and closing mileage, fueled on. Now on my userform i have a combobox populated with months and i...
Hi,
I have a multi page user form that I am using to predict scores for the premier league soccer fixtures each week. Within each page I have 1 fixture made up of a home team and an away team. This data changes week on week depending on the a web import. I want to add two images to each page...
Hi,
I have a list of soccer games on sheet "Web Import" with team A in column C and team B in column E. I want to create a user from for a user to input scores for these games. So when the user form pops up (once the spreadsheet is opened) it should present the user with the teams from the...
hi all
when i print my userform listbox the values of 1 column change to a different value
can someone tell me what i did wrong ?
screenshot of what i want to print
http://prntscr.com/keph0g
code of printing
Private Sub OUprint1()
Me.Hide
Dim rng As Range, wks As Worksheet, ListData()
'...
Greetings Folks,
I'm probably not in the right area but I have an idea that will make my job and the job of my peers 100000x's easier.
I was considering sitting down and redoing all the letters we send customers using UserForms or using Excel, somehow and googling until I figured out how to...
Hello all you lovely people.
Just a quick question, I have a userform that has a DTPicker (Calendar Date Picker) in it that shows today's date, how do I make it display the day before.
Thank you in advance.
Hi Team,
I have this vlookup code that I've been using. It is giving me the result that I need. However, I want the vlookup result to be editable. To be more specific with the problem, Whenever I choose a value from combobox1 then a corresponding value will appear in textbox1 however, I want...
Hello Everybody,
I have created a USERFORM which has command buttons namely CLEAR, ADD, SEARCH, UPDATE, DELETE, PRINT, CLOSE. All commands are functioning except UPDATE BUTTON. When I am searching a record through combo box, search result is perfect. But after making some changes in the record...
Hi!
Apologies for a bit of a nooby thread, I'm super new to VBA.
Simply put, I have created this userform and want it to show data within a listbox in the userform.
The data I have is stored on a worksheet and I want the listbox to also list new data once added to
the worksheet. The filtered...
Hi all, I would like to run a userForm with a specific name from a Module. Here is the code for my userForm.
Public Sub UserForm_Initialize()
'Adding the Options for fileDecision comboBox
With fileDecision
.AddItem "Append"
.AddItem "Copy"
End With...
Newbie to VB and I'm struggling to find a code to complete the above.
I have a UserForm for with 2 combobox's, the first is for category ("cmbCat") and the second for supplier ("cmbSup"). I would like to be able to upon initializing the form list data from "Table5[Category]" on worksheet...
Hi All,
I need you help with the Listbox in Userform,
I have two columns in Excel Raw file,
Column A has got categories and B has got the unique data.
I want to have all the Data from Column B in the list box, which falls in the category (From Column A) mentioned in TextBox1.
kindly assist...
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.