user form

I am trying to work with a User Form to send an email to my volunteers if they are a "No Show" selected on the User Form I have the code posted for the entire User form below, but the problem lies at the end with the email function. I am trying to use an index and match function using the name...

Hi All I was wondering if anybody knows a quick and dirty way for an excel (2013) user form to populate an access (2003) database. I have created the database in access and they match the questions in the user form but i'm having difficulty in getting the to to communicate (a connection has...

I can loop through all 10 ComboBoxes with the following code. [Code] Dim cmb As combobox, i As Integer For i = 1 To 10 Set cmb = Me.Controls.Item("ComboBox" & i) MyPNum = cmb.Value Cells.Find(What:=MyPNum, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart...

Hello, I have two excel documents that I use for project groups to document positive and negative experiences. The first document is a template for the project groups where they make their own copy and use it to enter information through a user form that stores the data on the document as well...

Hello all, I wasn't sure if this could be done as a formula, but basically, I am looking for something that would return the cell value of "Good morning" from 1:00-12:00, good afternoon from 12:01-17:00, and good evening from 17:01 to 01:00. is there a simple way to do this? The reasoning...

Hello everyone, I would like to create a user entry form that would create multiple rows in the Worksheet in the following way: The user form would have 3 TextBoxes, 2 ComboBoxes, one multiple selection ListBox and a button for the entry An user of this form would write in the random...

Periodically (but quite regularly) when I try to open a user-form it will open up but be blank. If I click the Esc key the form will fill but from that point onward (to click buttons or close the form) I must click the Esc key again before it will accept each action. Also, if I have VBE open...

Beginner vba user here on Excel 2013. I am creating a user form with two different combo boxes that draw from two different sheets within the same workbook. I have a last row function included for each combo box as the ranges may change from time to time. Here is my code: Sub...

How will you use a calendar or month view user form for this one? here are my steps: 1. when the active cell is in column B, a calendar will pop-up 2. From the calendar, i will choose multiple dates and hit OK button or ENTER in my keyboard*If I hit the ESC button on my keyboard, calendar will...

I have a somewhat complex user form with text fields, combo boxes, check boxes, and radio buttons. Sometimes, about 40% of the time when the user form is opened and starts at the first text box, keyboard commands do not work. This means that Tab does not go to the next field, Enter does not...

I have a UserForm that asks the user to select a day (Monday, Tuesday, Wednesday...) and input a position. I want to direct this information to the worksheet called Data. I want to the position to be inputed in the row that is associated with the day the user selected for it. The current code...

I have a user form that displays images. In my case, the bigger I can display the images the better it will be for the user. If I scale the user form for the display on my laptop's monitor then when I choose to use a larger external monitor the images are not nearly as large as the monitor is...

Hello, I am new to the forum but i'm pulling my hair on not being able to solve this one! I have database which is filled in via a user form. This user form returns the values to four different pages. I can get the user form to work if i just populate the "Receiver" tab. (The first one)...

Hello, Unfortunately I'm no big VBE hero and I don't have a basis code to start from, but this is my question. I created an excel document where I enter my expenses. All kinds of calculations happen and conditional formatting to get a quick view of budgets, results, expenses, ... It works...

Hello everyone The purpose of what I'm trying to build is to get the price at a certain location and at a certain week. For now my code is: Sub Price() price_path = Worksheets("Settings").Cells(1, 11).Value 'Workbooks.Open(price_path & Columns(50).Select...

Hello, I have searched high and low but to no avail. Please can anyone help...? :confused::confused::confused: I have built a user form in excel, which I need to be updated by multiple users, so I have shared the workbook. Upon clicking 'Save' the date is transferred to the next available line...

HI I am trying to loop through some (not all) boxes on a user form to lock/unlock them when a particular command button is clicked. The controls in questions all have names that start with "POinv" and then a number. I have the following code but it's not working as it doesn't seem to like...

Is it possible to create a form which repeats some of its fields, based on the value specified by user in real time. Ex: say the fields are, "Name:", "Type:", and "category:" . If the user value is 5 (Which will be available above those fields), it should repeat those three fields to the no. of...

Hello, I'm a new member here and this is my first post. I really appreciate any help you all might be able to offer. I am a bit new to VBA, but eager to learn, so your critique is welcome. I am creating a userform which uses combo boxes to collect Account Name and Account Number, and...

Hello, I have an Excel workbook with two different user forms. I want to use an Initialize event to populate some combo boxes. On the first user form, everything works great. When I try to use the second one, I get "Run-Time Error 424 Object Required". The debugger highlights the line in the...