Popup forms similiar to calendar control

[Clarence Perdue Jr.]

I was watching a video and this company had created a control in excel that would popup and allow you to enter information in the form and return one value for the excel cell. The pop up was similar to how the calendar control work. Do anyone have sample or video on how to create popup form with multiple fields that return one value for the excel cells. I am not UI/UX design but I am looking for some good example of how this can be done. I do not want to buy special controls.

 

[Luke M]

Here's two quick tutorials that should help you get started. Both are free.
http://www.fontstuff.com/vba/vbatut07.htm
http://www.ozgrid.com/VBA/excel-calendar-dates.htm

 

[Clarence Perdue Jr.]

I was watching a video in which a company had created a control in excel that would popup and allow you to enter multiple pieces of numeric information in a form field and return one value for the excel cell field that it popped up from. But not a calendar control. Does anyone have a sample or video on how to create a popup form with multiple fields that will return one value for the excel cell. I am not a UI/UX designer but I am looking for some good examples of how this can be done. I do not want to buy any special controls for this project.

 

[Clarence Perdue Jr.]

Here is the example of the excel popup form helper.