View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Garry[_7_] Garry[_7_] is offline
external usenet poster
 
Posts: 9
Default Object error on an Option Button

Hello

I have a userform with a multipage control with textboxes and a frame
containing an optionbox. The code for the option box is

If frmAddPayments.OptionButton1.Value = True Then
Sheets("payments").txtTax.Value = "Includes"
ElseIf frmAddPayments.OptionButton2.Value = True Then
txtTax.Value = "Excludes"
Else
txtTax.Value = "Non Taxable"
End If
What I am trying to do is to fill a cell with include exclude or Non
Taxable.
I use the DIM txtTax, txtType to declare the variables in the form
initialise statement.

I get the error object required. How do i refer to this and am I doing
it right?
garry

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!