Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Option Button Help PLEASE!! | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
conditional error for option button | Excel Worksheet Functions | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |