+ Reply to Thread
Results 1 to 4 of 4

merge cells when command button clicked

  1. #1
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    merge cells when command button clicked

    Hi, I have this worksheet for data entry. There are 2 command button for transferring userform data to sheet. What I hope to achieve is when user clicks the weekly maintenance button, column C to K of that particular row will merge and display "N.A".
    Attached Files Attached Files

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: merge cells when command button clicked

    Replace the maintenance button code with this.

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: merge cells when command button clicked

    Just add these code:
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  4. #4
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    Re: merge cells when command button clicked

    Thank you both for your help

+ 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] Return the control name of command button just clicked
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2015, 08:12 PM
  2. [SOLVED] How To Keep Running Program When Other Command Button Clicked
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2014, 12:23 AM
  3. [SOLVED] Pull a Hidden frame when clicked command button.
    By venkcris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2014, 08:52 PM
  4. Locked textbox clears text when command button clicked.
    By cocobean in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2012, 02:53 AM
  5. [SOLVED] UserForm Command Button - how to make it change appearance when clicked
    By schmidt62 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2012, 10:53 AM
  6. VBA to automatically move command button to another cell after being clicked on
    By vaznlyfe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 11:29 AM
  7. [SOLVED] Command Button does not re-set once clicked
    By Jurrasicway in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2006, 09:25 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