Edit/read from data base

[jagan]

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 .

 

[Mark Ivey]

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

 

[RB Smissaert]

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/mi...*+author:RB+author:Smissaert#f97bc1fa333007ec

RBS