+ Reply to Thread
Results 1 to 1 of 1

Command Button to Open Userform with Cell Values in Specific Range Preloaded

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    Seoul, South Korea
    MS-Off Ver
    Microsoft Office Professional 2016
    Posts
    1

    Command Button to Open Userform with Cell Values in Specific Range Preloaded

    Hello, everyone!

    I have a workbook with 2 worksheets; "Layout" and "ReservationSht".
    On "Layout", I'd like to have a set of command buttons for each of which a unique range-defining identifier is assigned. The identifiers are the first 6 characters of string values in the first column on the "ReservationSht". When clicked, the buttons will open a userform to edit and update data within their specific range on "ReservationSht" defined by their identifier. The range to edit and update is 6 columns by 2 or 3 rows depending on the first 3 characters of the identifier. The userform will open with text boxes for each cells within the predefined range loaded. And, preferably, in case of only 2 rows, I'd like to have the text boxes for the 3rd row not shown.
    "ReservationSht" file is attached.

    Any help will be greatly appreciated.
    Attached Files Attached Files
    Last edited by dragoneer; 02-24-2019 at 12:10 PM.

+ 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] Test for file open from Command Button on userform - not displaying open already message
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2017, 09:45 AM
  2. On current Userform, click OK Command Button to open new Window
    By eclairez7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2016, 09:53 AM
  3. Enterkng data on a specific worksheet using a userform command button
    By fbiasi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2014, 11:41 AM
  4. [SOLVED] how to stop Command button If specific number is entered in a specific cell range
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2013, 05:10 AM
  5. Changing Command Button Caption with userform Open
    By andrew c. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2011, 08:09 PM
  6. Userform Command Button to open new userform
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2010, 12:02 PM
  7. Command button code to write to worksheet and then open userform
    By Reidm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2008, 10:33 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