August 7th, 2013, 10:18 AM
Originally Posted by boblincs
In the days of Sinclair and Amstrad I became fairly proficient in Basic. With the advent of PCs I became lazy and never bothered with the new languages required. Now at 76 I've become interested again and dug out my VB 2005. Probably a case of old dog and new tricks.
I know to most of you this will be so simple but feel that a if someone would be kind enough to supply the necessary code the fog may thin if not clear.
I'm using excel and trying to build a for next loop for a sheet where column A contains a shopping list of 100+ items. What I'm trying to do is use a cell in another column where I can enter an item and the loop will take me to that item in column A and let me enter details, rather keep scrolling through the list. I know I can use the Find function but that's a bit long winded when tracking several items.
I seem to get halfway there but when I get to the code where if the Value of Column A = the search value I keep getting an error message about a missing object.
Trouble is, I've always found that examples in books never seem to cover the things I'm trying to do.
I've generally found that given a suitable example I can grasp the idea and use it as a basis for experiment.
So if someone out there has the time I'd appreciate the necessary code to carry out this loop you'd be doing me a kindness.
If you post what you have we can help more, but I'm guessing one of your columns is empty or null and your code isn't handling it right.