Dear,
is there a way to copy and paste combo box form controls keeping the input range static but the cell link relative in Excel 2007?
I've tried all my usual methods, but all seem to paste a combo box with absolute ranges and cell links.
I have to create many Combo Boxes then wanna drag & Copy them with relative cells link....
Can anybody Solve my issue plz.......
confused......????????
will you upload a sample file with example?
Regards
MAhaveer somani
Dear,
I had a combo box in cell A1 result of which is displayed in cell B1 i want to copy combo box from A1 to A2 and want to link that copied combo box with B2 automatically....
try this,
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
The code would depend on what kind of combobox you used.
Did you use a combobox from the control toolbox toolbar or a DropDown from the
Forms toolbar?
And a couple of alternatives.
Maybe data|validation. It kind of looks the same.
www[DOT]contextures[DOT]com/xlDataVal01[DOT]html
(Debra Dalgleish's site)
or even add all the comboboxes (or dropdowns) at one time.
Or even just have one combobox (or dropdown) and have it move to a different
cell (and adjust its linkedcell when you move it).
If the values in the list are always the same (and it sounds that way since
you're copy|pasting), having one combobox that moves maybe easier on excel.
yes dear ranjan82 i have one combo box (active x Control) in Cell A1 which is linked to Cell B1 now i dont wanna move i want to copy that combo box in Cell A2 and i want that the linkage of that Combobox Changes from B1 to B2 automatically..........
Sample file is attached....Plz Guide.
Hi waheed,
You assume that the combo box is attached in some way to cell A1. The Combo Box is just floating on your sheet and isn't attached at all. If you want a dropdown to attach to a cell then try to use Data Validation Dropdowns and tie them to a list.
See:
http://www.contextures.com/xlDataVal01.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
u r right Marvin i just stated Combo Box in A1 to Clarify. but in other way i want to create 100 combo boxes with same Data range but Continuous Linked cell value suppose 100 Combo boxes are Placed in cells A1 to A100 not in cells but i just want to Place(Float) in these cells is it possible to change their Linked Cell Value to B1 to B100..... i think now u will understand my Problem... is their any way to Create them or Modify them.... Plz Guide...
I cant use Data Validation as Data Validation do not fulfill my Requirements...
Why won't Validation do what you want? What are your requirements?
How about a bigger example with a few more drop downs...
Maybe you are giving up on data validation too early.
Data Validation lists are EASY
Active X Combo Boxes are HARD
Dear Marvin,
I have a database of dealer's in which total details of dealer is mentioned. now when i write in combo box it helps me to find the correct dealer name while data validation do not auto complete name of dealer and from linked cell i lookup values of Dealer's, that's why combo box is Required mainly for auto complete of Dealer name...
i have a collection sheet in which i have to place 100 or more combo boxes linked cells of which must be in series that will help in maintaining my Collection record..
You need to supply a sample of what you are dealing with. Replace private information with fake data. I'm sure there is a much better way to solve this problem than needing to have 100 combo boxes...
Auto Filters or Pivot Tables may give you exactly what you need. We just need a better example of what you are starting with and what you need to arrive at.
Plz check attached sample workbook....
try this solution ,
Very Good Xlbiznes it solved but plz guide how to setup new sheet like this.....
If you look at the code behind sheet1 , you will see the code below :
Please Login or Register to view this content.
Steps to utilize the code
Click on the developers tab
Click on visual basic
On the project explorer windows( left side of the screen) ,you will see excel objects under this you will see the sheet names.
Double click on the sheet on which you wish to implement the code.
You will see a white blank screen on the right side.
Now paste the code above into this.
You need to save your file as macro enabled workbook , which saves with the file extension .xlsm.
thank u very much xlbiznes. & All who supported me...
Hi!
I want to achieve the same result but the combo form box is not with Active X controls but with form controls. Will the above code be usable in this case? If not, could you please help with the modified/ adapted code? Thanks.
why you can't use Combo Box ?
Honestly? I'm not too familiar with Active X controls / Developer Options - just basics. Same with VBA. So I'm more inclined with the Form Control Combo box.
The use is to allow selection from a range located in a different sheet. The cell link value is then used in offset function to get other corresponding values to the selection made from the drop down list of the combo box.
And frankly,this is for an assignment I have at work - the competed file will be used by other users to compile relevant information so I'd like to keep it simple to avoid subsequent discussions.
I'd be more than happy to just have a short code to help me copy / paste form control combo boxes in a way that automatically updates the cell link.
BTW, thanks for showing interest and replying on a 4-year old thread!!
Can you upload Sample File. It will be easy to understand & solve your problem
Hi
Sample sheet is attached. Thanks for the help in advance.
Check attached, Highlighted area..
Thanks for the alternate solution with Data Validation Waheed!
But this does not work for me. As I said this is an overly simplified version of the problem. In reality I have multiple data sets and need to extract several fields from the master data. Would appreciate if you could help with the solution requested i.e. VBA code to ensure copying of the combo box (form control) object with updation of cell link automatically.
Try attached.
Thanks again! But nope doesnt work.. The Entire column C now has the drop down list and while it is possible to select the values of each object independently, it doesn't return a value in the cell link (didnt find the cell link?) which is to be used with for subsequent actions.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.Originally Posted by vpipalia
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Because this thread is so old I'm going to close it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks