Problem when adding a category

Folks,
In my workbook I have categories and topic list boxes. I know that I have to add a range in populating my Topics and Description and I have done that - kind of. I have added a range to the workbook, however, I do not know how to add a range called UserDefineDetectNumVal.
I am up to my 11th category now and have modified the code in the lstTopic_Click event as follows:
  Case 10
            Sheets("Menu").lblDescription.Caption = Sheets("Topics").Range("ArrayFormulas").Cells(intSaveLI + 1, 1).Offset(0, 1)

Open in new window

I also changed in the same sub procedure:
  If intCatFactor = 0 Then
        intCatFactor = 10

Open in new window

to
  If intCatFactor = 0 Then
        intCatFactor = 11

Open in new window


I have another worksheet that labels SheetNames and it corresponds with the Topics - the problem though is that when I go to select a Topic I am 1 off of the row I need to be on.
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Okay I'll take a look.
0
Martin LissOlder than dirtCommented:
Please attach your current workbook.
0
Frank FreeseAuthor Commented:
thanks - I've done all I know to do now - greatly appreciated
0
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Martin LissOlder than dirtCommented:
Don't forget the workbook.
0
Frank FreeseAuthor Commented:
Whoops - guess it would help.
I've return the workbook to its orginal defaults and I'm going to the right places now but I still do not have this "UserDefineDetectNumVal"ranged defined.
Excel-Formulas-and-Functions-Rev.xlsm
0
Martin LissOlder than dirtCommented:
Go to your Topics sheet. Then in Excel's 'Formulas' tab select 'Name Manager'. That's where you add, delete, and modify named ranges. You need to add a new named range called UserDefineDetectNumVal (or whatever you want to call it).

First however you seem to have a bunch of duplicate named ranges that you don't need. So In Name Manager select all the named ranges that have a 'Scope' of "UserDefineDetectNumVal" and delete them. That can be done all at once or one at a time.

After that to add the UserDefineDetectNumVal named range,
1) Click the New… button
2) Change the name to UserDefineDetectNumVal
3) Click OK
4) Select one of the other named ranges like Formulas, copy what's in the Refers To line, paste that into the Refers To line for the new named range, and change "$A" which occurs in 3 places to be whatever column the new data is in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
Ok champ - it looks like I'm moving forward again. I have no idea about those "other" named ranges.
As always, you are appreciated very much. This workbook is just beyond words - everyone that has seen it is blown away. To you I give the credit and rightly so. I continue to learn from this and have solved many problems on my own now.
Have a great day!
0
Frank FreeseAuthor Commented:
thank you
0
Martin LissOlder than dirtCommented:
You're welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.