Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Durham, North Carolina, USA
    Thanked 1 Time in 1 Post

    Mixing cells and Controls on a sheet (97)

    A guy I support has created a worksheet which asks people to enter data; the book is then emailed to him when they click submit. However, he has used a combination of regular cells and embedded controls (combo boxes, check boxes) on the sheet. If someone is typing in a cell and clicks a control, Excel doesn't "enter" the data in the cell.

    If he'd asked me earlier I would have told him to just create a form, but it's too late now. Is there a way to control the behaviour of the cells so they do "accept" the data when the focus moves to a control?

    The attached workbook has his sheet.
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: Mixing cells and Controls on a sheet (97)

    See reply to <!post=This post, 147885>This post<!/post>, which seems to be the same problem.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts