+ Reply to Thread
Results 1 to 6 of 6

Help with a macro that opens the data form "window"

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel for Mac 2011
    Posts
    12

    Help with a macro that opens the data form "window"

    Hi all!

    Unfortunately I'm a total newbie in VBA and macro, so I tried to record a macro which I want to open the data form so I can enter new data in my table....
    Please Login or Register  to view this content.
    but when I test the macro I get error 1004 at
    Please Login or Register  to view this content.
    I hope for your help with the macro.

    Thanks in advance, your help is really appreciated.
    / / Peter

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,185

    Re: Help with a macro that opens the data form "window"

    Hi, lelkes,

    I donīt know if the code works on a MAC but it certainly does on a PC:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Help with a macro that opens the data form "window"

    Showdataform usually fails in code unless your data starts within A1:B2 or your range is named Database. Where is your table located on the sheet?
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    08-30-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel for Mac 2011
    Posts
    12

    Re: Help with a macro that opens the data form "window"

    thx romperstomber
    Quote Originally Posted by romperstomper View Post
    Showdataform usually fails in code unless your data starts within A1:B2 or your range is named Database. Where is your table located on the sheet?
    The table i located in A5:B11 - with the heather in row A

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Help with a macro that opens the data form "window"

    Can you move it up?

  6. #6
    Registered User
    Join Date
    08-30-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel for Mac 2011
    Posts
    12

    Re: Help with a macro that opens the data form "window"

    Quote Originally Posted by romperstomper View Post
    Can you move it up?
    I'll try tonight when I get home from work.
    Last edited by lelkes; 10-20-2013 at 08:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. "Form and macro" to delete "Active" cell contents.
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 11:33 PM
  2. VBA - IE - click on "Open" in an internet explorer "file download" window
    By victoire in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 07:08 AM
  3. "Submit" Macro - Word form data to Excel
    By Greed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2011, 10:19 AM
  4. Excel opens "Save As" document preventing macro from looping
    By punkn00dlez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2010, 04:18 PM
  5. [SOLVED] Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook
    By JingleRock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2006, 12:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1