MapPoint Forums

MapForums

Community of MapPoint and Virtual Earth Users and Developers




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 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-26-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 01-05-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
http://www.techonthenet.com/excel/qu...eate_combo.htm
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 02-20-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
absolute, box, cell, combo, excel, link, relative


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Link Data to Excel update MP resets or can't place address GEB MapPoint 2006/2009 Discussion 3 10-01-2005 04:30 AM
Cell phone tracking from AccuTracking Anonymous News and Announcements 1 07-27-2005 08:48 PM
How can I link Mappoint with Excel? Anonymous MapPoint 2006/2009 Discussion 1 10-27-2004 06:17 AM
How can I link an Excel pivot table with Mappoint? Anonymous MapPoint 2006/2009 Discussion 0 10-27-2004 04:19 AM
Copying Worksheet with Combo Box Anonymous MapPoint 2006/2009 Discussion 0 07-20-2004 04:13 PM


All times are GMT -5. The time now is 03:53 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 RC2
MP2K Magazine
Visitor Map

Tenerife Holiday
Find a great deal on a Tenerife holiday through UlookUbook! Check out the options online...



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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59