VBA: Looked up data / now how do I change it?
 

I have developed a customized form that pulls aprox. 50 colums of data
into the form one record at a time from an excel spreadsheet.

Now I want to be able to change the data that was pulled into my
customized form. All the data pulled into the form populates into text
boxes.

is there anyway that if the data is changed in the text box, that I
could have the change information go back into the excel record?

Let me know if you can help.

thank you.

MC


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=273620

Hi
see as a starting point:
http://www.dicks-blog.com/excel/2004...g_userfor.html
http://www.dicks-blog.com/excel/2004...userfor_1.html
http://www.dicks-blog.com/excel/2004...userfor_2.html
http://www.dicks-blog.com/excel/2004...userfor_3.html
http://www.dicks-blog.com/excel/2004...userfor_4.html


--
Regards
Frank Kabel
Frankfurt, Germany


Mcasteel wrote:
I have developed a customized form that pulls aprox. 50 colums of
data
into the form one record at a time from an excel spreadsheet.

Now I want to be able to change the data that was pulled into my
customized form. All the data pulled into the form populates into
text boxes.

is there anyway that if the data is changed in the text box, that I
could have the change information go back into the excel record?

Let me know if you can help.

thank you.

MC