• 0

Visual Basic programing(excel) help needed


Question

Hi everyone.

I was just wondering if anyone knew a pice of code for entering a value in a text box and make it search for a value in a work book (3 sheets), finding its row number, and going across the row to another column to add 1 to its contents.

The scenario is a workbook with 4 pages. It has a ladies, mens and bags and a front sheet with a button. In the 3 sheets are data such as names and prices as well as a bar code number.

What i want it to do is: once the button on the front page is pressed, a form pops up with a textbox and a button. The user then types in the barcode number and when the button is pressed, it will find the entered number and its row number(A..) and move to (G..) on the same row adding 1 to the contents.

Sorry if this is long winded but I have been trying to do this for about a week and so far have ended up with nothing,

Your help will be extremely helpful

Adz

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.