1. gravanoc

    Need tips on using Excel to print onto a pre-printed form

    Later today or tomorrow I'll be stepping out of my comfort zone a little & helping setup a conduit program that, given a certain number of rows, will print one row of data onto a pre-printed form, then onto the next row & next form. This is a picture link of the form: Health Insurance Claims...
  2. P

    Excel 2019 mac. Userform not visible in VBA design mode

    I have just upgraded from Excel 2011 to 2019 I have a VBA project that includes 2 user forms. In 2011 when I double clicked on the form name it opened the form in design mode and let you add command buttons, delete them, position, etc. If you then clicked on one of the items it opened up the...
  3. L

    Office 365 Forms Spreadsheet housed on a server without access to 365

    I am creating spreadsheets for a client that uses Microsoft Forms to collect data. Some of their partners will be using the form to collect data within their organization, but they will own the spreadsheet and data until it is turned over to the client. Can that be achieved if the partner does...
  4. S

    Unusual Form Request

    Forms showing Multiple Records matching one field Can anyone help me, I have a massive amount of Data that I need to audit, Month by Month. The data is for Contracts, our company has with our clients. All Contracts have an annual renewal, so I audit the anniversary month for all contracts, to...
  5. S

    Sharing Excel Spreadsheets with Macros via Microsoft Teams

    Is there any information available on if it is possible to create an Excel Macro enabled workbook via Teams to allow for multi-user collaboration and updating? I attempted to create this using O365 Forms however with the standard version, there are limits for things like drop down lists and...
  6. T

    Form entry to create join between two tables

    Hi, I'm relatively new to Access. I have two main tables, essentially these are item masters with unique records: "SupplierParts" & "MyParts" Many supplier parts can relate to one MyPart i.e.: MyPart SupplierPart Part1 Part1 Part1 Part2 Part1 Part3 Etc... I have created a third...
  7. rinneii

    Excel Forms

    Hey! So I'm trying to make a form that will track purchase orders, which isn't what I'm struggling with. My question is, can I have a value (in this case, a purchase order number) returned to the user after they have filled out the form? Like as a pop up box or message box? Ideally the PO...
  8. W

    Form Closses but written conditions not implemented

    Hello: I have the following two codes in a button: The (first code) aims to submit value of option button into worksheet cell: For Each FormControl In Me.Controls 'Check only OptionButtons If TypeName(FormControl) = "OptionButton" Then 'Check the status of the OptionButton...
  9. I

    Data Entry Forms and Worksheet Restrictions

    I am trying to create a data entry form that can be sent to employees via an excel link that will only allow them to see the form and what they are entering on the form, not the rest of the worksheet. Is this possible? If not with Excel alone, is this possible with Excel and another program?
  10. T

    New to excel - Appreciate guidance

    I would like to set up an excel spreadsheet for stock trading where a form will ask for input for: Stock Symbol Trade Type Entry price Quantity That information will populated specific columns in the spreadsheet and the stock symbol also will be inserted between quotes in the Bid Ask formulas...
  11. D

    Strange "Out of Memory Error" on Close

    I have two files open. Both are pretty complicated with lot's of graphs, Shapes, pictures and formulas. File2 is the Active Workbook. When I simply Save File 2 from the "File" tab - No problem Then, I have a "Button" on File2, that calls a macro in File1, simply: Sub CloseFile2()...
  12. Z

    Linking Forms to another Forms

    My Boss asked for a hard task ( for ME) which requires To create a form and inside the form create a Combo Box where i can open a drag down menu and select an option and this option Automatically fill another form Linked to this one. For an example: Form 1 Contains the city, if i choose a...
  13. S

    Tighten up vb code for Access Database

    I have code in my Access Database that does the following: In a form (MainForm) that has a record source from a table called SectionTable. The below code is looking at the first record in SectionTable, running a macro that is using the first record from the table, then moving on to the next...
  14. S

    Tring to get VB code to automatically scroll through a table.

    Hi. I have VB code that looks at a table connected to a form and runs a macro ("ApdTabtoTotalTest"). I have it set up to go to the next record. It works, but the issue is that I have to manually run the code for each record. There are around 150 records. So I click a button and it runs. I then...
  15. S

    At a complete loss! Excel User Form VBA greater than formula not working!

    Hi experts out there...I am at a complete loss here! I've spent HOURS trying multiple things to get this BASIC code to work and it still won't work. I created a user form with 2 text boxes (TextBox1 and TextBox2) This code IS NOT WORKING for me: If Me.TextBox1.Value > Me.TextBox2.Value Then...
  16. M

    One Form, Multiple Query Sources (but not at the same time)

    Greetings! The setup: tbl_MAIN has all my data in it. frm_MAIN MENU allows user to search based on five fields, and opens another form: frm_DETAIL which displays all the tbl_MAIN data on one screen. It's useful but it's kinda crazy and busy. It's good, I like it. frm_MAIN MENU also opens up...
  17. earwig999

    Import data from PDF in to Excel

    I am trying to create a Macro in VBA to Import data from either single or multiple PDF forms in to an Excel workbook. Adding each form as a new row in the sheet. I am thinking of a Button with the macro attached on the Sheet, which then identifies a folder containing the forms. It then pulls...
  18. L

    2 forms

    Hi I have 2 forms. UserForm1 and UserForm2. Do I need to say UserForm2.Label1.Caption or just Label1.Caption I did "Label1.Caption" and everything work fine, it is not effecting the UserForm1 The code below is for UserForm2 Private Sub myadd_Click() UserForm2.Label1.Caption =...
  19. A

    Variable file location

    I have a folder that is a template for multiple forms. I wrote a code that open the forms and publishes to another location. Works fine. My problem is that since this is a template that my users use to make a new file the location changes The area in red font is my issue. my simplistic...
  20. V

    How to open VBA forms from VBA Application (exe file)

    Dear All, Please guide me about how do i open vba forms and coding pages from one my vba application file type.. Pls guide someone..
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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