Edit/read from data base
 

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 .

Edit/read from data base
 

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 .

Edit/read from data base
 

As you mention database, maybe you could use SQL to retrieve and alter your
data:
Plenty of examples on the net, but this thread may give you a start:

http://groups.google.co.uk/group/mic...c1fa333 007ec

RBS


"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 .