I am working on a two sheet workbook right now full of customer information, with each customer's info being kept in a seperate row. I need to create a form that can call up each of the records. I have already made a large amount of text boxes that display the first record I am wondering if there is anyway I can code buttons to make the linked cells in the text boxes go 1 number higher or 1 nunmber lower to call up subsequent records?
Retrieving Records from another worksheet using VB Forms
-
-
-
can you attach your file so we can see the code?
if it's big just create a smaller sample file to give us the basic idea (ie with just a few rows in it)
-
I made a simple example which should be benefical.
Please see attachment for the solution.
Thanks
Bob. :guitar:
-
Thanks for your help. I was out of the office all weekend so I didn't see any of your posts till this morning. I actually fixed the spreadsheet by having the forms retrieve from a row that was populated by a VLOOKUP. Here is how it works.
Sheet 1: This worksheet consists of the forms that display the data needed. In the top corner I have a spot where the user can punch in the record # they want.
Sheet 2: This just consists of one row working on a VLOOKUP. It matches the record number from sheet 1 to the records on sheet 3.
Sheet 3: This sheet consists of all the records that have to be called up. The record number is in the leftmost column so that it can be called up from the VLOOKUP.If anyone sees problems that may arise in the future from setting it up the way I did, please respond. This spreadsheet doesn't go into full use for another two weeks so I still have modifying time. (oh the joys of setting your own deadlines
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!