There's several ways of doing this.Here are some:
1) copy the unique info to your second sheet and name the range. Then, use
this named range in the "RowSource" attribute for your combobox in the
userform.2) "initialize" event macro for the userform, Read through the data
and load unique values into an array. Then, in the initialize event, set the
combobox to the array.
I can try to put together an example.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Isaac Rosser <irosser3...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Thursday, December 10, 2015 4:47 PM
Subject: $$Excel-Macros$$ Macro Popup Window with Combo Box based on Cell
values that might change
Hi All,
I'm creating a macro that automatically runs upon opening the workbook. (Not
the issue) My problem is that I don't have experience with popup windows and
encorporating them into macro's. I want to create a macro that will present a
popup window that has a dropdown(combo box) of all values from a certain
column. Once the user selects a value from that dropdown, the macro should
continue to run, and will delete every row that does not contain the value
selected from the dropdown. The issue is, that over time, I would like the
dropdown list to automatically update. My trick for this is to copy the enter
column to a new sheet, and use those cells to populate the combo box each time
the macro runs.
Let's use this as an example
I have a list of Animal Types, and different breeds of each animal. Dogs, Cats,
Fish, and Horses.
This list of animals has been copied to Sheet2 column A, and removed all
duplicated to condense it to Range("A1:A4")
I can't seem to populate my combo box popup window with those values, and upon
selecting one of those values from the dropdown, populate Cell B2 on Sheet2.
Any help would be greatly appreciated!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
