Results 1 to 3 of 3

Survey Form controls - Formatting issues

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    77

    Survey Form controls - Formatting issues

    Hi all; I'm not sure where to post this as it's not about functions or formulas, charts or pivots. I sensed the VBA and macro guys might know hence putting this here.

    I have Excel 2007 and have added multiple slider style form controls to a worksheet. My sheet works well and the formulas are designed to carry on calculating if a survey question (a row) is deleted. This all works fine only if I delete the row, the slider remains and if you delete a few, they all stack up on top of each other and often become deformed shapes.

    Ideally, if I delete a row I want the form control to go too!

    I'm also interested in fixing the size of the control. I've specified 0.5cm high and 6.5cm long but this seems to not work. Aligning them is a nuisance and is all done manually. Can I fix the size, lock it to a cell and delete it automatically if I delete the row?

    Sample attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Form Controls / Active X controls to record and log information in a seperate sheet
    By marcbarnett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 05:00 AM
  2. Replies: 1
    Last Post: 05-01-2014, 05:15 PM
  3. Conditional Formatting with Form Controls. I'm stumped
    By DAC_LCS in forum Excel General
    Replies: 2
    Last Post: 05-24-2012, 11:03 AM
  4. Replies: 9
    Last Post: 02-14-2011, 06:42 AM
  5. [SOLVED] User Form Caption controls beyond formatting
    By Vacation's Over in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1