Forum Discussion
Trying to create a new form using Vba and Macros
While I'm new to this but watched and tried a lot for this project. I have a requirement to create a form that looks like this, well I created the dropdown and the button but to have the data in a...
You've had 75 views (and counting) without any replies. That kind of disparity usually means that what you're asking is unclear. That's definitely the case here. For starters, the data you say you want to collect isn't provided for in the supposed "output" and some things are in that "output" that aren't accounted for in the input. In other words, there are a lot of major gaps that make the whole situation hard to follow, and therefore hard to respond to.
You would be more likely to get some help if you could describe more fully the full process, not in Excel terms (or with rough and inaccurate mockups that are incomplete).
- Describe in plain English vocabulary such things as: who is to be entering the raw data; what that raw data consists of, where it comes from, how frequently it comes, etc.
- Then what the final result is to be (i.e., how is the data to be used and for what purpose; not how it is to be stored or manipulated while waiting to serve the ultimate purpose).
- And anything else that would be what people typically call "the big picture."