+ Reply to Thread
Results 1 to 3 of 3

Merge Cells with Command Button Feature

  1. #1
    Registered User
    Join Date
    06-02-2018
    Location
    USA
    MS-Off Ver
    Office 16
    Posts
    8

    Merge Cells with Command Button Feature

    Hello again, still new to all this. I created a command button and when clicked I would like it to merge some cells and enter specific information in that merged cell. Is this possible?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Merge Cells with Command Button Feature

    Hello
    Try recording a macro with those steps and you will get the code
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Merge Cells with Command Button Feature

    Try to avoid merging cells, more often than not you will find it causes problems later.

    Try using 'Center across selection' instead. (Right click, format cells, alignment, horizontal)

+ 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. Replies: 2
    Last Post: 02-02-2016, 10:27 PM
  2. Insert Command Button that will Activate Command Button on a Different Sheet
    By realvirtuality1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2016, 02:11 PM
  3. [SOLVED] merge cells when command button clicked
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2016, 02:16 AM
  4. VBA code to create command button. Print all sheets then delete command button.
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 05:18 PM
  5. Loop Command to unmerge existing merge cells
    By ahlecks in forum Excel General
    Replies: 3
    Last Post: 07-01-2010, 03:50 AM
  6. Replies: 1
    Last Post: 09-17-2007, 09:57 PM
  7. Replies: 0
    Last Post: 11-03-2005, 11:00 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