PDA

View Full Version : How to create user form



svsaug6
04-18-2013, 10:55 AM
dear,
i want to create one user form like shown in this picture below.
right side 3 options need to input form the user and clicking on the button get option chain, it gets the data from www and fills all the columns frm expiry to optn int..
any idea on creating this form.
http://www1.picturepush.com/photo/a/12525389/640/Anonymous/options-chain-in-excel.jpg (http://picturepush.com/public/12525389)

thank you in advance

SamT
05-26-2013, 10:17 AM
Sv,

Sorry it has taken so long to respond, I don't usually get down to the Project Assistance folder.

How much of the Look and Feel of that form have you been able to recreate?

Please upload it here.

We will need to know what every CommandButton, TextBox, and ListBox is supposed to do, and what Ranges they are supposed to refer to.