To show the userform with out saving changes in Excel

jagadeesh

New Member
Joined
Sep 24, 2002
Messages
3
Hi all,

I have a macro which is assigned to a button in Excel (custom toolbar).
By clicking that i get a form which is designed in VBA.
It is working fine, if i make any changes in excel and if i click that button
with out saving the changes , it is not showing me the form ,
If i save the changes and click on that it is showing the form.
I don't want to do like , whether it is saved or not, if click on the
button it has to show the form. What to do for that.
Do i have to change the code to save all the changes by programmatically and
call that form or any thing else more
Here another problem is that if i change data in cell and click on the any other cells
than it is working fine and if i stay in that cell the click on the button it is showing nothing
and in VBA editor it not working until i save the data or click on the any other cell.

Kindly help on this...

Thanks
This message was edited by jagadeesh on 2002-10-04 00:00
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Fryer Tuck

Board Regular
Joined
Mar 20, 2002
Messages
64
When you edit data and then click on the button, are you still in the edit mode for the cell? (If you have not pressed "Enter", the button may not work.)

Other than that, look at the source code for the button. There may be something there disallowing the form to be shown.

F.T.
 

Forum statistics

Threads
1,143,640
Messages
5,719,984
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top