Newbie1Kenobi 0 Newbie Poster


Newbie1Kenobi here. I have a project where I have an Excel file with 2 columns. Each column has an exclusive number. What I want to do is to create a form in VB express that would have a textbox, a label and a button. I would input a number in the textbox and when the button is clicked, it opens my excel file, searches column1 of the excel file for the number and when it finds it, it would move one cell right (column2) and display the value in column2 as the label caption. Thus far, I am able to open my excel file, but cannot figure out how to search for a specific number inputted into the textbox.

Does any one know if this is possible to do?


Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.