+ Reply to Thread
Results 1 to 4 of 4

Help with using command buttons

  1. #1
    Registered User
    Join Date
    01-12-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    73

    Help with using command buttons

    Hello experts,

    I have the following situation and trying to solve using vba.

    I have few sentences in "sheet1". one in cell "B3" and other in cell "B9" and i have placed two command buttons named "Insert" and "clear" against each sentence, so that when ever "Insert" button is clicked the respective sentence will be copied in cell "D1" of sheet 2, and "clear" button to "clear" the respective sentence. When more than one sentence is inserted i am trying to have one line gap between them.

    Please help with the code that is to be written in "Insert" and "Clear" buttons.

    Thank You.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Help with using command buttons

    Assign to each command button respectively (assuming you are using form control command buttons)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-12-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    73

    Re: Help with using command buttons

    Quote Originally Posted by stnkynts View Post
    Assign to each command button respectively (assuming you are using form control command buttons)

    Please Login or Register  to view this content.

    Thank you very much for taking out your valuable time and helping others.

    The above code is working good except that "clear" button is deleting the entire content in the cell, instead of clearing only the respective line. from cell D1

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Help with using command buttons

    Do you mean this?

    Please Login or Register  to view this content.

+ 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. Useform Code - 12 Command Buttons dependant on other command buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 10:58 AM
  2. Master Command Button to call on other Command Buttons located in other Workbooks
    By MrNickRegan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 07:57 PM
  3. Code for a master command button to change the backcolor of multiple command buttons?
    By panttherm5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:11 PM
  4. Linking command buttons to option buttons
    By sealtite01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2012, 12:25 PM
  5. command buttons:label of a command button
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2008, 07:16 PM

Tags for this Thread

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