user forms

Hello! I am trying to create a user form that makes a user select a name from a Listbox and two options from checkboxes and returns the average of "days" and "amount" for that name selected from the listbox . I'm new to VBA and having trouble setting up the code to do so. Does anyone have any...

Hi all, I've built a VBA macro within a .xlsm file, but I want to make the user interface look a little more professional - at the moment, when the user opens the file they see a standard Excel blank workbook with a large 'Start' button in the middle of it (not very subtle). Is it possible to...

I have a user form that provides the end user with a simplified display of information, I need to populate a text box with the word 'Blocked' if the value in the workbook = 0

Good day Everyone Hope the week is treating everyone well so far. I have a VBA code for a user form that is running extremely slow. The code is as follows: Private Sub cmdaddentry_Click() Dim Rowcount As Long Dim ctl As Control If Me.txtshift.Value = "" Then MsgBox "Please enter...

I'm beginning to learn to code in Excel, and I have a question about grouping items. I have about 100 different "types" of items that are separated into about 5 groups based on how I describe the item. I created a user form that allows you to choose the item from a tiered drop down list and...

Is it possible have a command button that adds more boxes with the code below the existing ones? The user form has 3 rows, but it needs to have the ability to add more, since the project can have 40 jobs. User Form to create a budget., It contains the following boxes like on a row, one next...

Being relatively new to userforms and some VBA code I have attempted to draft a macro for a command button. The code in essence is supposed to do the following: 1) Once you select a scheme name (one) and list of staff (one or more)y 2) You press the command button and this inserts new rows in a...

I'm having trouble with pairing two sheets. I have two excel worksheets: Sheet 1 has keys and Sheet 2 has values. Is there a way to embed a form on sheet1, that will display the associated values for the keys in Sheet1 pulled from sheet2? So, if you click on A1 in sheet 1, the form will...

Dear all, How I can extract multiple text box values in a userform to an excel sheet through a VBA for loop. VBA script is written below. ("tb_Model" & i portion is having error) 1. Tbl_Orders is an excel table 2. tb_Model1, tb_Model2, tb_Model3, tb_Model4 and tb_Model5 are text boxes in...

Hi All, I am creating a user form in Access 2007. I am receiving a Compile Error within my VBA coding. Please take a look at the code below and see if you can help. Compile Error: Expected: End of statment Recived on line: DoCmd.OpenForm “frmPasswordChange”, , , “[UserID]" = ” & Me.cboUser...

Hi, I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848...

Hello, I have created a database with multiple tables in Access 2013. i have had no problems getting the relationships for the drop boxes set up. Where i am struggling is getting a unit price from one table, to be multiplied with a entered quantity in a fox text box to create a total that...

I have another issue where I'm stumped, I've used this same code on 5 different other forms and it performs as it should on them but on my current worksheet, it continues to "overwrite" the previous data instead of moving to the next line in the table. My code is as follows: On Error...

Hi, I have 2 sheet in my workbook. The first worksheet "Inventory" contain the incoming stock. The second worksheet "Track Out" will contain the outgoing stock. I have create a userform in my Track Out sheet like this: and my Track Out list will look like this: Here will be my inventory...

I've noticed that not only do I need to select my choice from the listbox, I need to select it again (to get the blue highlight) before my selection is detected. Is there a way to use VBA to add the highlight once a selection from the listbox has been made or is it possible that I'm just...

I merge several letters per day, from a database that I have in Excel. For each merge, I have to create a new Word document from a template. To do this I go to the mailings tab; Click on Edit the Recipients List and select the recipient. This can get very tedious indeed. Is there any way that I...

Hello forum! I have a spreadsheet using an Input Form (user cannot get to the spreadsheet to enter data - they must use the form). This is working well. What I need to do now is allow the user to retrieve data that is already entered. Example: Spreadsheet has 100 unique records (rows)...

1st, I'm not much of a VBA guy, but I'm sure this will be the only way to solve my problem. I have a user form that writes records to another sheet in my workbook, I would like to build another user form to recall a record from the "Database" worksheet allow users to change any of the fields and...

Hi all, I new to the site and still a bit new to VBA. What I am trying to do is open a user form and allow the user to pick a file (perhaps a few files in the future) open it and display the file name with one button click. Then use another control bottun to do the work of getting the needed...

Thanks for looking at my post.. I would like to have a user form pop at 2 certain times with a simple message in it and a OK button. If someone has not clicked on the button by a specific time the user form will close so it will allow other macros to run...... I used the code below for msgbox...