Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » VBA » Data entry through VBA Coding

Data entry through VBA Coding

Previous | Next
Latest post Mon, Mar 29 2010 7:07 AM by Teppic_. 1 replies.

  • Tue, Mar 9 2010 6:09 AM

    • Arup
    • Not Ranked
    • Joined on Tue, Mar 9 2010
    • Posts 1
    • Points 21

    Data entry through VBA Coding

    Reply |Contact

    Hi..I am using Excel 2007. I have a data set where I am having data on revenue for various geo location, products etc. now for each geo and products there are codes(images). I want to write a VBA code  which would automate the data entry process and the size of the images should be driven by revenue fig..As revenue fig will increase the size of the image should increase. Please let me know if you need any urther information. Thanks in avdance..
    • Post Points: 21

  • Mon, Mar 29 2010 7:07 AM In reply to

    • Teppic_
    • Top 50 Contributor
    • Joined on Fri, Apr 3 2009
    • London UK
    • Posts 20
    • Points 228

    Re: Data entry through VBA Coding

    Reply |Contact |Mark as Answer

    Have you looked at using a bubble chart? you can even use custom pictures with this chart type and it will do all the re-sizing for you.

    To do this in VBA is possible, but it will be ardours. you're best bet is to use the macro recorder to do one or two and change the code...
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.