Is it necessary that it is on a userform???

If not, I would recommend setting up a Sheet just for this type of view.
Since you are already using VLookup, it should not be too difficult to set
up on the other end (at least I don't expect it to be too difficult from
what you have mentioned here).

If you really want a form view... you can design your own and add as many
fields as necessary. The real issue involves all the code behind the
userform to insure a correct read when a data point is changed.

Let me know if I can help...

Mark Ivey

"jagan" wrote in message
...
I am having a data base in Excel in sheet1(45 coloumn) and i want to
edit data calling every row now i am using Vlookup , i would like to
use something similar to form but this limited to 32 columns. Can
anyone help me in this connection a macro to read instead of form view
in the excel sheet similar to vlookup .