lw22
07-03-2009, 08:07 AM
Alright well I made this spreadsheet for someone I work for where a macro automates some calculations. I have a user form in the sheet that will help make some of the manual tasks the user has to perform easier. The problem is the user has to edit the Excel file while the user form is open however they need to close the form before they can edit anything. Is there a way I can have the user form open and still edit the spreadsheet. Preferably without minimizing the form as well.
Also, is there a way to bind keystrokes to userform buttons? I was hoping I could bind escape to the cancel button
Also, is there a way to bind keystrokes to userform buttons? I was hoping I could bind escape to the cancel button