Consulting

Results 1 to 2 of 2

Thread: Assign value to shape by double clicking

  1. #1

    Assign value to shape by double clicking

    Hi everyone,

    Can anyone help with vba code on assigning value to a shape in an excel sheet through double click event.
    I have a number of different types of shape on the sheet, I want to be able to assign values such as time value etc. to each one by just double clicking on them.

    Thanks in anticipation

  2. #2
    VBAX Guru mancubus's Avatar
    Joined
    Dec 2010
    Location
    "Where I lay my head is home" :D
    Posts
    2,644
    hi.

    searhing the vbaExpress forum and other online help communities may help you solve your problem without opening a thread.

    check this out:

    http://www.vbaexpress.com/forum/show...ent-for-Shapes
    PLS DO NOT PM; OPEN A THREAD INSTEAD!!!

    1) Posting Code
    [CODE]PasteYourCodeHere[/CODE]
    (or paste your code, select it, click # button)

    2) Uploading File(s)
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.

    3) Testing the Codes
    always back up your files before testing the codes.

    4) Marking the Thread as Solved
    from Thread Tools (on the top right corner, above the first message)

Posting Permissions

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