Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2021, 06:07 PM
Frenchie_King757 Frenchie_King757 is offline Tick Checkbox from Cell Value Windows 10 Tick Checkbox from Cell Value Office 2016
Novice
Tick Checkbox from Cell Value
 
Join Date: Jun 2021
Posts: 5
Frenchie_King757 is on a distinguished road
Default Tick Checkbox from Cell Value

OneDrive Link:
Microsoft services

I have attached a link to OneDrive for the file. The file comes from Nsutradhar - Excel Tutorials.



I have changed the code to work on the actual workbook I am using, but the example accomplishes the same thing. The final product has 34 columns and I have it coded to just show the first four columns of the sheet in the listbox. Columns further up would show up in the UI as check marks showing it has met the criteria. For example, in the workbook attached, you search for "computer" and it shows in the listbox, in the datasheet, under Column ABC there is an "X" for computer. I was trying to have an IF statement that would match the value from TextBox1 and if there is an "X" in ABC, then the CheckBox will tick. I am pretty new to arrays and it throwing me off. Any help would be appreciated.
Reply With Quote
  #2  
Old 07-13-2021, 07:10 PM
Frenchie_King757 Frenchie_King757 is offline Tick Checkbox from Cell Value Windows 10 Tick Checkbox from Cell Value Office 2016
Novice
Tick Checkbox from Cell Value
 
Join Date: Jun 2021
Posts: 5
Frenchie_King757 is on a distinguished road
Default New OneDrive Link

New Link to OneDrive, accidentally deleted the first one:
Microsoft services
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox - toggle hide/unhide other checkbox - XMLMapping GErl Word VBA 9 11-19-2020 03:15 PM
Table cell auto-shading when checkbox ticked. markt Word VBA 2 08-05-2020 06:13 AM
Table cell auto-shading when checkbox ticked. markt Word 2 07-10-2020 08:53 AM
Tick Checkbox from Cell Value How to link checkbox to change nearby cell value? derby46a Word VBA 15 11-14-2017 01:02 PM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM

Other Forums: Access Forums

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


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