That is, Insert a new row if a specific value does not exist if it does then update some. Check presence of values in a column/range using Excel VBA Most often a programmer would be given a job of Insert/Update scenarion in EXcel.Now as i got the list in the ComboBox, When I select a value from the ComboBox, for example, it should reflect in the Cell A1. Let me explain the second question in detail. Re: Linking Combo Box To A Cell In Worksheet.I’m creating a general OLEObject even though I specify the class. I set some other properties like Value to start with them all unchecked, LinkedCell so I can test the cell value later when I hide rows, and Caption because a caption would be superfluous. This will cover the entire cell and hide the TRUE and FALSE from linking the checkbox.