View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default Intialize a checkbook

I want to initialize my userform when it opens. I know how to do this for a
Textbox:

Dim rng
Set rng = Cells(ActiveCell.Row, 1)

'Places data in the userform text boxes if it exists on the spreadsheet

' Misc.
TextBox1.Text = rng(1, 3).Text 'First Name
TextBox2.Text = rng(1, 4).Text 'Last Name

But how do you do this with a Checkbox?

It would be looking at rng(1, 7)