Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Cell Link for combo box in Excel : Relative or absolute?

This is a discussion on Cell Link for combo box in Excel : Relative or absolute? within the MapPoint Desktop Discussion forums, part of the Map Forums category; Cell Link for combo box in Excel : Relative or absolute? Well, using only 1 combo box is fine without ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Cell Link for combo box in Excel : Relative or absolute?

    Cell Link for combo box in Excel : Relative or absolute?


    Well, using only 1 combo box is fine without caring about cell link's being relative or absolute. But when I copy the cell containing the combo box, I need the cell link to be relative.
    Here's something to visualize the problem:
    Think of an order form. I got 100 orders in the list. And I got a column which I want to put a combo box with selections "paid" or "not paid" . Well, I put my first combo box in my first order. But when I copy that cell down for the remaining 99 orders, all the combo boxes that I created (for the other 99 orders) all are linked to the FIRST order's combo box's cell reference. However I want that cell's reference to be relative so that when I copy the cell(and the combo box as well, as that cell contains containing the combo box) their cell link is changed. I need this cos I may have 10000 orders for example and modifying all the cell refeences of all those orders's combo boxes may be annoying.

    Any help is welcomed. Thanks in advance.

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Quote Originally Posted by Anonymous
    http://www.techonthenet.com/excel/questions/create_combo.htm
    That doesn't answer the question... I am also having a similar problem to Ali and can't find a way around it!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell phone tracking from AccuTracking
    By Anonymous in forum News and Announcements
    Replies: 2
    Last Post: 08-26-2009, 12:17 PM
  2. Link Data to Excel update MP resets or can't place address
    By GEB in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-01-2005, 05:30 AM
  3. How can I link Mappoint with Excel?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-27-2004, 07:17 AM
  4. How can I link an Excel pivot table with Mappoint?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-27-2004, 05:19 AM
  5. Copying Worksheet with Combo Box
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-20-2004, 05:13 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27