Common Userform and coding for the same.

[Pramod KLN]

Hi Everyone,

I wanted a common userform where in the User will enter the Worksheet name and Range for populating multicolumn (5 Columns) listbox and worksheet name for storing data after data entry.

In my workbook every week two sheets will get added one with multicolumn listbox data another with user entered data based on multicolumn listbox.

My sheet1 will be book stock of that week and sheet2 will be physical stock against that book stock along with remarks if any variance is found.

I wanted add everyweek two sheets in to the same workbook - one bookstock for that week and another physical stock of that week against the book stock.

Is it possible to create such userform? If yes how to code the form and do data entry?

The userform will contain two textboxes to enter the sheet name and Range (Columns)

one multicolumn listbox to populate book stock records (Rowwise)

Two textboxes for physical stock and remarks for each row of the book stock in the same order.

Thanking in advance,

Pramod