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.
Bookmarks