Validation criteria

K

Kanmi

I use validation from DATA menu on excel to create dropdown that have list of
DOWNSTRM AND OFC. How can i use the dropdown menu to pull up information that
belong to each of them. i mean whenever i select DOWNSTRM then it should pull
up down DOWNSTRM information on the other page that has macro link to this
page. the code below:

Private Sub CommandButton1_Click()
ask = MsgBox("Build safety report?", vbYesNo, BoxTitle)
If ask = 7 Then Exit Sub
BuildDetailReport
MsgBox "Done", , BoxTitle
End Sub.


i want it to pull up information belong to DOWNSTRM when it selected and
pull up information belong to OFC when it selected on sheet name "Due Date".
Please can anybody advice on what to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button 7
Private Sub 2
Compile Error "Invalid Outside Procedure" 1
Validation 5
Dynamic Naming of Form Button 3
List all tables, including document structure 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Making a macro only work on certain files 2

Top