Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2022, 08:23 AM
Jan Eikeland Jan Eikeland is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2021
Novice
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.
 
Join Date: Aug 2022
Posts: 5
Jan Eikeland is on a distinguished road
Default Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.

Hello.

Scenario:
Windows10, MS365
Xcel.

ComboListBox activeX
4 datalist in another page called: Data
1 linked cell


I try to list data from 1 of 4 diffrent lists, shown in 1 combolistbox (and its 2 columns)



Choices, shown permanent in 1st column
"DATA1"
"D...2"
"
"
all choices of string type

Lists:
List1 List2 List3 List4
Max 170 lines of data in each list or and better, use actual number of items in each lists

The linked cell is set to a free cell, containing name of choice choosen.

What I try to achieve is:
when data(stringtype) in free cell is altered, set listfillrange to proper List (1 of 4) which will, hopefully
show the content of list in column no 2 in the combolistbox :)
The code belw is surely, at its best, very poor as this is all new to me.

VB code
Private Sub ComboBox1_Change()
If ComboBox1.LinkedCell = "Skedsmo" Then
ComboBox1.ListFillRange = "Data(a2:a113)"

End If
End Sub
Reply With Quote
  #2  
Old 08-13-2022, 08:32 AM
Jan Eikeland Jan Eikeland is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2021
Novice
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.
 
Join Date: Aug 2022
Posts: 5
Jan Eikeland is on a distinguished road
Default

ah, I probably need the choice list and 1 empty list. Last one, to be filled with 1 of th 4 lists.
Reply With Quote
  #3  
Old 08-13-2022, 02:39 PM
p45cal's Avatar
p45cal p45cal is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Best attach a workbook with this in.
Reply With Quote
  #4  
Old 08-13-2022, 07:18 PM
Jan Eikeland Jan Eikeland is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2021
Novice
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.
 
Join Date: Aug 2022
Posts: 5
Jan Eikeland is on a distinguished road
Default

What I hope to achieve is:
A combodropdown list on each row (starting at row 2), in column N (Gard) achieveing this:

showing 4 detectable items:SKEDSMO SØRUM NES BLAKER NITTEDAL (SHOWN IN label Data) in first column of combobox

Clicking on one of theese items,i.e.: SKEDSMO, will show all data beneat this in
the 2nd column of the same combobox.

Pic1 in sheet named Work
Pic2 in sheet named Data

regards
Attached Images
File Type: png pic1.png (2.1 KB, 8 views)
File Type: png pic2.png (22.7 KB, 7 views)

Last edited by Jan Eikeland; 08-13-2022 at 10:57 PM. Reason: moving pictures
Reply With Quote
  #5  
Old 08-13-2022, 09:37 PM
macropod's Avatar
macropod macropod is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,719
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

@ Jan Eikeland: Kindly attach images to your posts here (via the Advanced tab) instead of inserting links to other web sites.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 08-14-2022, 03:45 AM
p45cal's Avatar
p45cal p45cal is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

A workbook please! Not a picture of one…
Reply With Quote
  #7  
Old 08-14-2022, 08:17 AM
Jan Eikeland Jan Eikeland is offline Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Windows 10 Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Office 2021
Novice
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.
 
Join Date: Aug 2022
Posts: 5
Jan Eikeland is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
A workbook please! Not a picture of one…
Problem solved elsewhere. Thank You.
Reply With Quote
Reply

Tags
combolistbox, vb code

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Find duplicates in colums by row only akol1214 Excel 3 10-04-2018 11:58 PM
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Excel colums are wrong way around SteveL Excel 1 05-06-2015 02:09 AM
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. How to change colums to values CoachJohn Excel 2 06-14-2014 05:36 PM
Fields/Colums in folders cilimpuli Outlook 1 03-10-2013 12:20 PM
Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists. Add _ based on a calculated colums stovaaa Excel 4 03-09-2012 08:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.


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