Hi, i have managed to create a userform that requires one to login to the excel application with username and password using . How do i modify the vba code such that it only applies to one specific worksheet instead of the entire workbook? Thank you.
Hello,
I would like to be able to hyperlink a cell to a specific document but it isn't working for me, here's what I had in mind
I have already created an existing user form. It comes up with a range of textboxes that are linked to specific cells but what I would like to achieve is when the...
I am having trouble with one of my userforms. I have set up a simplistic input for Receiving and have a nearly identical one for shipping. The receiving works fine (See first) but shipping will not work on it's page. Is there something I must change when using multiple userforms in the same...
Hello all, I've configured the following workbook to manage our IT workorders and create a ticketing system. Everything I have is working with exception to closing a ticket. I've tried wrapping my head around this one and keep drawing a blank and I'm hoping someone here will have a revelation as...
HI ALL , WILL TRY TO EXPLAIN AS SIMPLE AS POSSIBLE
SO I HAVE A USERFOM WITH 80 CONTROLS(TEXTBOXES ,COMBOBOXES ) I HAVE NAMED THEM AS "FIELD" FOLLOWED BY A NUMBER
EG. FIELD1 ,FIELD2,FIELD3 UPTO FIELD80
DATA FROM THESE FIELDS ARE ADDED TO THE DATABASE SHEET IN EXCEL BY ADD BUTTON ( I HAVE USED...
The issue that I am having is that I need to populate a text box with a pay rate based on data in two combo boxes. So the way it would work is that the user would choose the employee name in one combo box and than the Earning code in a second combo box. Than I need the pay rate to be placed in a...
I built a quick userform on my Windows 10 PC and it ran perfectly fine after I enabled the Microsoft InkEdit Control 1.0 field. However, following the same steps on another Windows 10 PC (I've now tried 3 different ones) does not work - the userform crashes.
Specifically, I've narrowed down the...
I have a userform listbox where I want to filter data using two parameters - ALL, Parameter1, Parameter2. With the code that I have written I am only able to filter data using Parameter1 not Parameter2 or All. By default, 'All' is selected which should show all records in the listbox. There are...
Hi
Can someone see why this doesn´t work.
If I choose a certain element in the first Userform1, I like another to pop-up (Userform2) unless I pick the value that become True.
Even if the value in "A11" become TRUE it will still show Userform2. I don´t know why.
Sub Choise()...
First, the customer will login through the login userform.
Then, they can start ordering the food, afterthat, it comes to the check out form.
I don't know how to auto-fill Member ID, Phone no., name, address and current member points from the customer sheet.
* Member ID=Ref_ID/ Name = User_Name...
I have some records being displayed in a listbox. I have a hide button in my userform which when clicked hides the row selected and the row remains in the excel sheet. But if I open the userform again then the data loaded has all the hidden rows. I have created a row 'Active' and assigned it...
Hello,
I have an excel spreadsheet that shows multiple accounting years (Fiscal Year, Calendar Year and some Operating Years) that gets updated a few times a year and am wondering if the best/easiest way to update the years for each accounting year is to have a userform open and we select the...
Good morning!
I have created two user forms in VBA, one that enters "Sample Details" and creates a new sample number, then another that allows the user to edit and enter testing data for the sample. However, I'm having an issue with one textbox not populating the value from the text box into...
I am filtering data in the listbox using values selected from two combo boxes. I have made a separate listbox for the headers. The code I have for filtering is also printing the headers. How do I stop the headers from getting printed along with the data?
Private Sub FilterData()
Dim Manager...
I am filtering data using two combo boxes from an excel sheet and updating a listbox. No matter what the results are I always get one blank row in the listbox but the excel data has no blank values or blank rows. Why is this happening? How can I resolve it? Here is the code for filtering and...
hello :)
my userform has two buttons PREVIOUS and NEXT to show data from the row before, or the row after the active cell row :)
but: on clicking in my data list to open the userform, it does not show anything, so now i click NEXT and then PREVIOUS and
then i get the data from the active cell...
hello all :)
i'm putting a NEXT and PREVIOUS button on my userform to see other data (from other rows) ...
strangely they work only once, and i think why: the activecell.row is stored in a variable, but in the datalist the active cell
remains on the same row.
how can i change my code to make...
Hello!
I'm working on a macro and i need some help.
I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR.
I'm giving an example below.
Lets say i have the below table and my...
Hi Experts,
I have a workbook with a User Form with two radio buttons (a,b), an 'OK' Command Button and a 'Cancel Command' Button.
On Sheet1("Form") I have a command button that loads the User Form.
I also have a module in VBA, where I would like to write a subroutine (called by Clicking the...
I would like to prepopulate a user form text box, however I would like the content to be presented in columns as shown in the included image. Is there a way to accomplish this?
Thanks in advance!
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.