Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2010, 01:15 AM
ioustinos ioustinos is offline Combo Box in whole column Windows XP Combo Box in whole column Office 2003
Novice
Combo Box in whole column
 
Join Date: Sep 2010
Posts: 3
ioustinos is on a distinguished road
Default Combo Box in whole column

Hi there, i want to create an input form for a client of mine



Every row is one entry, and one of the cells (hence the whole column) needs to be a combo box. I have managed to create a combo box and attach it to one cell. Lets say B2.

However i cannot do what would seem a simple thing. I am a newbie...
For the reason that i cannot know before hand how many rows my client will want to use, i want him to be able to copy paste a row and instantly the new combo box to be attached to the appropriate cell...For example if i copy ROW 2 and paste it to row 3, i would like the new combo box to be linked to B3.

Should be simple i guess...
Reply With Quote
  #2  
Old 09-01-2010, 01:24 AM
ioustinos ioustinos is offline Combo Box in whole column Windows XP Combo Box in whole column Office 2003
Novice
Combo Box in whole column
 
Join Date: Sep 2010
Posts: 3
ioustinos is on a distinguished road
Default

To better explain my problem,

Currently when i copy paste a row containing a combo box, changing the selection of any combo, will change the selection to all combo boxes...

Moreover if i delete a row, the combo box will not get deleted. It seems that the combo box is completely independet from cells and rows.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms - Combo Box Linking data tomkat Word 1 04-23-2010 06:28 AM
Bold list items in a combo box DrewB Word VBA 0 07-17-2009 11:32 AM
VB Code.. COmbo boxes DrewB Word VBA 4 06-10-2009 05:31 AM
Combo Box in whole column Hide a combo box DrewB Word 3 06-08-2009 11:29 PM
Combo Box in whole column Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft