Posted to microsoft.public.excel.programming

Paul

external usenet poster

Posts: 108

Option button problem

Hi, using XL 2000

I have userform with 3 option buttons.
They all share the groupname BizType.

The user can select 1 of 3 options.
Option1 = Sales
Option2 = Purch
Option3 = Return

How do I dynamically update cell; Worksheets
("EnqHead").Cells(newrow, "C") with the current selected
option button value?

Many thanks,

Paul

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
option button ?	Dan	Excel Discussion (Misc queries)	6	December 27th 07 08:42 PM
Option Button Help PLEASE!!	KB	Excel Worksheet Functions	1	April 26th 06 06:21 AM
Option Button	Pieter van der Walt	Excel Discussion (Misc queries)	2	March 27th 06 12:02 PM
keep source formatting is not an option in paste option button	Tina	Excel Discussion (Misc queries)	0	February 20th 06 09:58 PM
option button	Mario	Excel Discussion (Misc queries)	1	July 26th 05 07:44 PM

All times are GMT +1. The time now is 09:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us