+ Reply to Thread
Results 1 to 2 of 2

Button to Select next available cell on another sheet

  1. #1
    Registered User
    Join Date
    12-27-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Button to Select next available cell on another sheet

    I have this code linked to a button on sheet "Entry" to pop open a form that enters data on "Data"

    Please Login or Register  to view this content.
    Getting an error on the bold line.

    TIA.

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

    Re: Button to Select next available cell on another sheet

    Hi, Gondi,

    Application.GoTo doesnīt require the Select command you put in at the end of the line. As you havenīt listed the other macro I changed the code which worked for me showing the standard DataForm from Excel but AFAIK requires the Selection to be in the range for the database:
    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

+ 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. [SOLVED] Select column A's cell in relation to the row that macro button was clicked on?
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2013, 12:24 PM
  2. Replies: 0
    Last Post: 03-13-2013, 03:14 PM
  3. Select a button on an active cell
    By Einstahb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2011, 04:48 PM
  4. VBA Cell Select Button
    By mworonuk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2009, 12:36 PM
  5. won't select cell on another sheet
    By smit127 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2005, 09:49 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