form

  1. W

    ClearContent not working

    I have the following code. It doesn't work. Says, "1004 Error", when implemented. Don't know what have done wrong. Private Sub CommandButton1_Click() Unload Me ThisWorkbook.Sheets("Set Exams-Answers").Range("F21, H23:H26, F31, H33:H36, F41, H43:H46, F51, H53:H56, F61, H63:H66, F71, H73:H76...
  2. H

    Excel VBA Display text box vs. Input text box values fail to transfer with display text box method, Compile error: Method or data member not found

    Hi, I have 2 scenarios where: 1. I have an integrated VBA form where values are input manually in a textbox and I get results outputted successfully. I was able to find an i.e. =embed((m1r1) command in the textbox but can't seem to access it again. The first sheet has code like this...
  3. T

    Hide the formular and auto-caculation if match conditions

    Hi All, I got a form and supprise, just in case how to do automatic caculation after you input some cells, pls find my excel file for more supprise and help to guide me. Thank you very much and best regards, Pls check file sample: https://drive.google.com/open?id=1a2-eztbki-yC73g2b7o1bXVfXbsNTvuY
  4. A

    Copy Paste User Selection from Form to Excel.

    Hello guys, I have a form where it will display the random questions from "Questions" Sheet to the User. User will Select the Answer in the Form. I Need to Save all those Random Questions (as of now its 10) and Answer which User attend, Save it in "Answer" Sheet. Can you please Help on this...
  5. bobsan42

    WithEvents Form AccessObject ... conundrum

    Hello all. My goal at the moment is: To open Form1 as background, make it translucent, then use the openArgs to pass a name to open Form2 on top of it. When Form2 is closed Form1 to close automatically. I achieved it easily with DoCmd.OpenForm but then I have to set WindowMode:=acDialog, which...
  6. L

    Excel standart form

    When making a new row using the standart excel form tool it takes the row to the bottom, but is it possible to make it add the row in between 2 rows?
  7. R

    Database form that can capture file address and save to cell in hyperlink format

    Hi, I have a database form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the...
  8. W

    data search vba

    I have a large Q&A spreadsheet with rows that include question, answer, category, sub category, and date updated. I am looking for someone to create a form in which I can search with the option of filtering by category. I am thinking a place to insert the phrase or question (and be able to...
  9. M

    Excel Table - Form Wizard (Custom DataForm)

    Hi, I have a table, many headers and records. This is in Excel and unfortuneately needs to remain in Excel rather than move to a database. I'm looking to create a userform to display the record data and allow the data to be amended / written back to the sheet. I can do this with the 'DataForm'...
  10. H

    VBA - User Form show at start of macro & hide at the end

    Hi, I have a user form(UserForm1) which I want to show at the start of the maro & hide at the end i.e. when the macro/code is completed. The purpose for this is that some codes do take few seconds to complete so I would want a user form (stating some text like the macro is ruuning - pls wait...
  11. D

    data entry form

    I have looked in google and not found the answer to this question. 2 actually First is it possible to edit which fields appear in the data entry stock form. I do not want all of the columns to show up in it. I have formulas in some of them that will calculate based upon the what data is...
  12. M

    Help with Macros

    Can anyone help I have created a form and everything is submiting, but the data is not transfering to the data page which I want the information to be stored on. if anyone is willing to help Im happy to send the form across. It should be a simple fix but Im not a wiz at excel.
  13. A

    Filling cells based on a pull-down

    Hi everyone! I have a spreadsheet we want to use as a sort of fillable form for non-tech savvy people to send us data in. The problem is, there are columns they don’t need to fill in depending on which one of several dozen selections is made in a different column. The original solution to this...
  14. K

    yes/no pop up message box

    Hello everyone, I have a command button that opens up a user form, I would like to add a yes/no message box to the command button and when cell "A4" =01 (01 representing today's date). My message would read"do you want save the data and delete before entering new months data". If yes is...
  15. gheyman

    Access: VBA to identify User and rights

    I have code that checks a table to see if the Current User should be able to open a form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _ "[Object_Name]='" & Me.Name & "' AND [UserName]='" & CurrentUser()...
  16. S

    VBA help for data entry form

    <tbody> Team1 Team2 Team1Run Team1Over Team2Run Team2Over Tie? NR? </tbody> I have this form to be filled by a VBA form. I followed many VBA Form codes but unable to correctly enter data into the form. This form is located in sheet MatchData starting cell A1. I have a form...
  17. T

    Find next blank line then paste data

    Hi, On the Service Order tab (Link below) there is a button that runs a macro to extract certain data form the Service Order form then paste to the imported Data sheet. How can I continue to add different but new data below the last pasted entry in the Imported Data sheet? Code to find next...
  18. Z

    Image Click event

    Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form. I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image where Image 1 is the name of the image that i want to click on to open the form. any ideas ?
  19. F

    Code will not copy full list

    Hi The Code below looks at a dynamic list of information in a worksheet "Teams & Runners Data Form Entry" and should copy all the information in Columns B:E and paste it into the sheet "Team List" columns A:D. However! It currently only copies 10 of the 18 rows in the "Teams & Runners Data...
  20. 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()...

Some videos you may like

This Week's Hot Topics

Top