+ Reply to Thread
Results 1 to 7 of 7

Move vba click button

  1. #1
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Move vba click button

    Hi I have a vba click button on sheet 2 which performs a simple delete row. However I'd like to move the button to sheet 1 but still make the vba perform the delete row on sheet 2.

    Cheers

    Dave

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Move vba click button

    Hi

    What's if you add in the first line of your code?

    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Re: Move vba click button

    Hi it's coming up with syntax error, I've renamed sheet2 to B as that's the name of the sheet.

    Sub Button3_Click()
    sheets.("B").select

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Move vba click button

    What's your (whole) code that you use?

  5. #5
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Re: Move vba click button

    Please Login or Register  to view this content.

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Move vba click button

    Perhaps

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Re: Move vba click button

    Hi it comes up with another syntax error however I changed your original "sheets.("sheet2").select" to just Sheet2.select and that now works.
    Thanks

+ 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. Button Click on Spreadsheet commanded by Button Click on Userform
    By Quilie19 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-07-2015, 11:35 PM
  2. How can i print filter report or move to new workbook by click command button
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2014, 09:01 AM
  3. [SOLVED] click on a color button and after button click it will color entire row of cell you click
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 06:06 PM
  4. How to click macro - Move right 15 cells - Next click move back to home position
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-05-2010, 10:47 PM
  5. After click on button move to specified column in the active row.
    By danusko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2009, 06:19 AM
  6. Move the page with button click?
    By horton in forum Excel General
    Replies: 1
    Last Post: 07-05-2008, 01:11 PM
  7. [SOLVED] Move the cursor to a cell in button click event
    By Man Utd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2005, 12:05 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