Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Control Confirm problem
I'm using radio buttons to switch between modes (New & Edit) in an Excel
Worksheet. Each of these modes has associated controls and code. When a user switches between New & Edit, their "in-progress" changes will be lost. I want to ask them to confirm that they want to do this and lose any unsaved information. I've been using a VB Yes/No box with the message ("Do you want to switch to New/Edit and lose unsaved information?"). The problem is when the user selects "No". Here's a typical problem workflow. User is working in "New" mode. He clicks the "Edit" radio button. The radio button is selected and on click() the confirmation box pops up. User doesn't want to lose unsaved information, so clicks no. Radio button reverts to "New" mode. However, in reverting back to "New" mode, Excel now pops up the opposite confirmation asking if the user wants to enter new mode, etc, etc. Clicking "no" everytime leads to an endless loop. Help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Control Confirm problem
Hi Steve4446
Just in case... Are you exiting the sub after the user selects No??? i.e. If Result = vbNo Then Exit Sub end if |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing radio button control | Excel Programming | |||
How to control radio buttons on a web page? | Excel Programming | |||
Problem: Control Toolbox Control resizes when clicked | Excel Programming | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions | |||
Control Radio Buttons to VBA | Excel Programming |