VBA help with message box to search multiple sheets in variable columns

Jmoz092

Board Regular
Joined
Sep 8, 2017
Messages
184
Office Version
  1. 365
  2. 2011
Platform
  1. Windows
  2. MacOS
Hi, I inquired within another post here about utilizing a message box to search data in a sheet. It was recommended that I begin a new thread to ask questions as my questions differed from the OP's in that thread.

Here is the question I asked in the other thread:

On one sheet I have 4 columns, with 4 rows to each column. Each column's 4 rows of cells is a validated list pulled from a named range from their own sheet in the workbook.
Sheet 1 B13:B17 is populated from a named range on Sheet 2
sheet 1 D13:D17 is populated from a named range on Sheet 3
sheet 1 F13:F17 is populated from a named range on Sheet 4
sheet 1 H13:H17 is populated from a named range on Sheet 5

Sheet 2 has data in columns E and F that are concatenated in column G.
G1:G464 is the named range for the validated list on sheet 1 B13:B17

Sheet 3 has data in columns A and B that are concatenated in column D
D5:D535 is the named range for the validated list on sheet 1 D13:D17

Sheet 4 has data in columns E and F that are concatenated in column G.
G1:G459 is the named range for the validated list on sheet 1 F13:F17

Sheet 5 has data in columns F and G that are concatenated in column H.
H1:H541 is the named range for the validated list on sheet 1 H13:H17

Also, Sheets 2-5 are hidden from the users.

The validated lists are very long, but serve a purpose insofar that they concatenate a number with a description. This is then selected, to suit a given scenario, into the cell. After some user feedback, it seems that waiting for the numerically ascending ordered validated list to scroll down to their desired selection is "tedious" and "time consuming". I thought a search box specific to each named range above each of the columns may be a helpful solution to the users' feedback.

As an add on inquiry, is it possible to choose or select the result of the search and then have it populated into the next empty row of the column that the search box belongs to?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,223,909
Messages
6,175,310
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top