form

  1. T

    Sending excel file through outlook365

    I have been using an Excel-based form for years with a macro button that automatically sent the form as an attachment in an email through Outlook. Locations that have since switched from Outlook to Office365 say the button no longer works. Does anyone know where I can find the macro...
  2. MFish

    VBA Click option on a Combobox to another userform

    Hi, What I'm trying to complete is this - I have a combobox1 that has data, "1-1", "1-2", etc. and within this same user form (userform1) there is 3 different option buttons to choose from. I want to write a code that executes this... I want to show userform2 when I choose optionbutton1, no...
  3. K

    Workbook Name

    Hello I have a master workbook template that many people use for a request form, as soon as they press SEND the origional form is kept on there local drive as a blank form. However the sent file is saved on a network location with its own unique workbook name, My question is that on the...
  4. MFish

    Combobox, after selection, bring up another form

    Hi, I'm needing a way to go an extra step after a selection was made in a combobox for a user. Example: I'm having the user choose a 3 letter acronym and this will designate a defining pallet to a location.. (We're a shipping company) Once this 3 letter acronym is chosen it will bring up...
  5. synergy16

    splitting text after previous space

    good afternoon all. i have a vba program that populates text/list boxes on a form, based on a users request in the form. it reads off a excel sheet that has delivery information for fedex shipments. the cells that contain the delivery "street address" are giving me an issue because they...
  6. D

    Print button that prints the listed parameters

    I am fairly efficient with the internal commands of excel, but VBA's are very new to me. It took me 4 hours to program a saveas button, but with a lot of internet searching I was able to determine where my issues were. Now I have been trying another button on the same page for a "Print"...
  7. B

    Linked Workbook/Data Connection Issues

    What I have is one Workbook serving as a Data Entry form. That form populates another Workbook that serves as a Database. From that database, I have a third Workbook that I have data connections in back to the database to analyze the data in different ways (Pivot Charts, etc.) The problem I...
  8. gheyman

    ACCESS: Table Field equal another Field in the Same table

    I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I...
  9. W

    Help with Run-time Error '91' with code

    I have a userform that I am trying to get working. I have the inputs all set, make the validation, set it if correct but can't seem to get past the 'copy the data to the data base'. Here is my code: Private Sub CommandButton_Add_Click() '----------------------------------------------------...
  10. K

    VBA: Command Button Always at Bottom Right of Form

    Hi I have created a dynamic form which will vary in height depending on user selection I have added a scroll bar so the user can scroll up and down the form i would like to add a Command button that would always be at the bottom right of form , is there a VBA code which can do this ? Thanks...
  11. S

    Excel form received but macro not forwarding file on

    Hi all, New to macros and thought i would try and create one for a new form. Basically, individual1 completes the form and uses the macro to submit to individual2 who then approves/rejects and uses another macro to send to individual3. The first bit works fine but when the second user...
  12. A

    Form Navigate

    Is there any way to have Navigation buttons (like Access record selectors) on an Excel Form? I have a Form displaying pictures.. and would like to enable Next-Previous-End. Because the picture uses the whole Form (and can be dragged smaller/larger) extra controls on the Form aren't ideal as I...
  13. synergy16

    usage counter

    Good afternoon all. is there a function in VBA to have a "counter" to record how many times a form gets used?
  14. M

    Loading... message box

    I have a complex macro that takes several seconds to complete. It is activated by clicking the "Close & Save" command button in UserForm19. Due to the delay while the macro is working, I'd like to create a "Loading..." message that will let the user know that the macro has started and to...
  15. MFish

    VBA User Form Recognition?

    Hi there, I'm very new to the VBA side of Excel. I understand Excel Spreadsheets but not much on the VBA side. I had a question about excel understanding what is selected in a User Form while you start marking things off. Here's my goal, may get confusing... I have locations in my company...
  16. B

    filtering in a form, data validation dependent lists

    Hi I have a rules database 4 columns, circa 500 rows(all cells populated). Column D has ALL unique values(the rules) Column A 37 unique values,B and C similar(the descriptors). If you want to find a rule in column D you use A-C to narrow down the search. Easy with filters, but I want to build...
  17. M

    Change the color of a row in a form if criteria is met

    Can anyone tell me how I can change the color of row data in my form if it meets this criteria and how would I create the query if it already has a select statement that populates the form... * Distribution Type: In-Service Withdrawal * Disbursement Amount: $50,000.00 or more *...
  18. M

    How many userforms can excel handle?

    Long story short I'm still about one years old using VBA and I'm making a spreadsheet with multiple semesters in column A. In column B is tuition, and in column C is fees. I just started making this so I haven't gotten very far, but I currently have it set up where when you click on cell C1 a...
  19. D

    Excel VBA Macro works on Step Into Mode but not in Run Sub Mode

    When running a macro in "Step Into" mode it performs correctly. When running the same macro in "Run Sub" mode it fails every time. In the "Run Sub" mode I receive an "Exception occurred." error message followed by "Run-time error '1004': Method 'Range' of object'_Global' failed" message. I am...
  20. W

    Locking Worksheet w/ password and conditions.

    How can I the password to apply automatically. This gives me an error. Also can I set it so I can copy data form a specific column [e]or from the status bar? ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True "password"

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top