Writing to a Excel Table via VBA

Hi,

I wanted to know if this is possible?

(Made up Data)
Table1
CustID | Validated(Y/N) | Comments | Order ID | Product
1 N TEST 1 ABC
1 N TEST 2 DEF
1 N TEST 3 GHI

So lets say thats my table.. And its being displayed in a Pivot Chart so as you can image "1", "N", "Test" are not being repeated

OK sorry about the lame example I can't put up the actual one coz its confidential stuff

So basically I have this table I created from a query (No it's not going to be Data Connection table its going to be completely on its own) as soon as I have figured out how to do this

So in my pivot chart I want the user to be able double click on that validated field. so it prompts them with a Popup Form
which contains combobox for Y/N and a comments textbox.

So when I save I want it to change all of those "N" related to that custID to "Whatever is in the combobox" & all the "TEST" to the "textbox"

I had this as a data connection where that save button updated the table field in Access DATABASE, but unfortunately this individual is not connected to our network they are on a different network so my Connection String becomes invalid.

so.. I would like to be able to change the table in excel itself if possible?

I hope I made sense you can ask me anything if you have a confused as to what i want again.

[Summary]
This I want to know:

• Using VBA to change all Field Values in Column Validated WHERE CustID = 1

Things I already know & have done:

• Pivot
• Excel Userform

Thanks in advanced


_____________________________EDITED___________________________

So far I have only been able to come up with:

Please Login or Register  to view this content.

Does anybody have any better idea's that looping through the table?