PC Review


Reply
Thread Tools Rate Thread

Edit cells with user form open

 
 
Miree
Guest
Posts: n/a
 
      30th Oct 2008
I had a lot of macro buttons

so put them into a user form so there was only one button on the sheet.

Is there a way that i can edit the cells with the sheet still open?


 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      30th Oct 2008
Hi,

Set the ShowModal property of the userform to false

Mike

"Miree" wrote:

> I had a lot of macro buttons
>
> so put them into a user form so there was only one button on the sheet.
>
> Is there a way that i can edit the cells with the sheet still open?
>
>

 
Reply With Quote
 
Miree
Guest
Posts: n/a
 
      30th Oct 2008
Perfect thanks

"Mike H" wrote:

> Hi,
>
> Set the ShowModal property of the userform to false
>
> Mike
>
> "Miree" wrote:
>
> > I had a lot of macro buttons
> >
> > so put them into a user form so there was only one button on the sheet.
> >
> > Is there a way that i can edit the cells with the sheet still open?
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help! Click data on form and open another form to edit the NDClark Microsoft Access 0 1st Aug 2008 09:43 AM
Open a form on click to edit data from a Multiple Item Form NDClark Microsoft Access 2 31st Jul 2008 12:17 PM
Tabbing thru User-Edit Cells in Protected Sheet ConfusedNHouston Microsoft Excel Misc 2 13th May 2008 11:44 PM
Open form in edit mode to add contents - but open by user last name JNariss Microsoft Access Getting Started 1 14th Dec 2005 09:06 PM
Open a form from a datasheet form to edit Dan Microsoft Access Form Coding 1 22nd Oct 2003 02:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:30 PM.