Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

control source formulas

Status
Not open for further replies.
ckhunley

ckhunley

Technical User
Jul 26, 2004
33
US
I am trying to create a userform which interacts with a database. I have textboxes whose control source are linked to cells on the spreadsheet. I select one piece of equipment from the database and copy its info to the cells which are the controlsources for my textboxes. This uploads the current values into my form. I want to be able to make changes to the values in the form, and have those translated back to the spreadsheet. The problem is that the spreadsheey contains formulas, so when I alter a textbox it overwrites all my formulas with values, so they don't respond to changes I make.
Any way to keep them as formulas?
Thanks,
Chris
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
860
strongm
strongm
Andrzejek
  • Locked
  • Question
Catch control from control array
Replies
3
Views
358
strongm
strongm
Alt255
  • Locked
  • Question
Using bookmarks in local files with the Web Browser control
Replies
6
Views
430
Alt255
Alt255
AncientTiger
  • Locked
  • Question
Disabling compatibility mode with the webbrowser control
Replies
2
Views
407
AncientTiger
AncientTiger
Auguy
  • Locked
  • Question
Replace Base Class of Textboxes on Form With My User Control
Replies
2
Views
319
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top