Results 1 to 5 of 5

Excel Code Not Working As expected

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2010
    Location
    Melbourne Australia Down Under
    MS-Off Ver
    Excel 2010
    Posts
    56

    Excel Code Not Working As expected

    Hi

    I have a small problem with the code attached to the spreadsheet. It will not display the dataform

    Sub DataEntryForm()
        Range("A9").Select
        ActiveSheet.ShowDataForm
    End Sub
    I get a error message "Run time 1004"

    I would like to start at Range(“A9”)

    I have searched google for a solution. Found a couple but could not get them to work.

    I have attached the spreadsheet.

    Many thanks
    Attached Files Attached Files
    Have a great day!!!!

    Lou

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel VBA RemoveDuplicates not working as expected
    By mcwsky09 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2014, 12:06 AM
  2. Excel Pro. Plus 2010 - Chart template not working as expected
    By mycroft in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2014, 09:17 PM
  3. Excel autofill not working as expected
    By avp3000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2013, 02:14 AM
  4. [SOLVED] 'Find' not working as expected (Excel vba).
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2013, 12:01 PM
  5. [SOLVED] Avoiding page breaks across merged cells - Code not working as expected
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2005, 11:05 PM

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