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.
