Feed a TextBox Value back to a Cell in Excel and/or an Access table 1

[dddivers]

Hi - I have created a UserForm in Excel VBA (version 2003) that has Checkboxes folks can click to make particular choices. I have coded the checkboxes to feed Textboxes (which are also located on the UserForm)....the purpose of the Textboxes is to show the added (or subtracted) value when a user clicks a particular Checkbox (to show grand totals to keep track of number of checkbox items selected).

What I want is for TextBox3's calculated value (which is the grand total) to immediately feed back to a cell in an Excel worksheet (being used as a database to collect data). This needs to happen before the user closes the UserForm.

Not sure how to code an Excel cell's value to equal the value of a textbox located on a UserForm.

Does anyone know how to do this?

Also, would love to know how to take that same Excel UserForm textbox value and have it feed back to a table in Access if anyone knows how to do that. THANK YOU!

 

[johnwm]

Try the VBA forum or the Access Forms forum. Read faq222-2244 to get the best from these forums

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts