Thank you Paul, I was able to get everything to work now. Much appreciated.
Results are now chosen via a listbox, and the selection(s) from this
listbox decide which rows of data to keep from the master list.
Thanks again!
On Friday, December 11, 2015 at 8:29:01 AM UTC-5, Paul Schreiner wrote:
>
> 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 >
> *To:* MS EXCEL AND VBA MACROS >
> *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...@googlegroups.com .
> To post to this group, send email to excel-...@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 a
