#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
New OneDrive Link
New Link to OneDrive, accidentally deleted the first one:
Microsoft services |
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 |
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 |