Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nisha Gor   on Mar 23 In MS Office Category.

  
Question Answered By: Seth Anderson   on Mar 23

You don't link frames  or other controls to sheets, you write code for the
individual controls that does whatever you want it to, including putting
information into worksheets of your choosing.

In the design environment, double-click on the control you want to process,
then write the code to handle the information from that control.

This can include accessing a sheet  by name. E.g.

Option Explicit

Private Sub TextBox1_Change()
Worksheets("Jim").Range("A1").Value = TextBox1.Value
End Sub

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on User Form Or get search suggestion and latest updates.


Tagged: