user form

  1. M

    excel 2013 user form to update access 2003 database

    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...
  2. R

    Looping userform ComboBox 1-10 with associated TextBox 1-10

    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...
  3. U

    Ignoring a read only in a different document

    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...
  4. andrewb90

    Change value of cell based on time of day

    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...
  5. X

    UserEntryForm Dependable multiple selection and entry of multiple rows at the same time

    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...
  6. B

    Form freezing, Esc key for evey subsequent action required

    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...
  7. I

    Userform Combo boxes not linking to multiple different sheets

    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...
  8. I

    Pop-up Calendar to choose and display multiple dates

    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...
  9. J

    Tab, Escape, and Enter keys not working sometimes in user form?

    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...
  10. A

    Input Data From UserForm In Correct Format in Excel in VBA

    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...
  11. S

    Changing a user form's elements sizing with input from worksheet or user form

    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...
  12. B

    VBA UserFrom - IF/THEN Function

    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)...
  13. K

    Excel 2013; User form to add data into looked up cells

    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...
  14. R

    Dynamic Workbook path

    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...
  15. N

    VBA User Form in a shared workbook

    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...
  16. C

    User Forms - loop through controls to lock/unlock

    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...
  17. S

    Dynamic Form Fields

    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...
  18. E

    If Statement only evaluates "False"

    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...
  19. B

    User Form Initialize Error

    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...
  20. K

    How to create a vba user screen in excel to be filled out....

    Hello, I have an excel spreadsheet workbook that has multiple tabs. The 2 tabs that I want to focus on is "Requirements" and "Version Control." When a line on the requirement tab is in need of being changed I would like a macro to be pushed and then have a user form appear that has the...

We've detected that you are using an adblocker.

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.
Go back
Back
Top