Excel pop-up window

[dmccallum]

I maintain the checkbook in Excel and have a macro that assigns accounting codes to each check based on who the payee is. I would like a pop-up window to appear everytime I start to enter the description so I could choose from the pop-up window.

How?

 

[Klae]

Go to Insert | Form... in the VB editor and then you get a nice blank form to design and program. Once you have your desired form with a drop down combo box of whatever then in your macro code use [i[formname[/i].Show You're only as good as your last answer!

 

[JVFriederick]

Very easy.

List all the descriptions in a vertical table somewhere in the spreadsheet. Now move back to the checking account data entry area. Place cursor on one of the cells for "description", then use select Data Validation LIST and then refer to the list you just created.

A pulldown list will appear, which is a list of descriptions.

This new cell sort of behaves like a formula, which means it needs to be copied for each data record to be of any use.

 

[dmccallum]

I don't see a place in Data Validation LIST to refer to the list I've created.

 

[JVFriederick]

within Data Validation,
Settings tab,
Validation Criteria - Allow :

then pick LIST from the pulldown.

sorry I wasn't more descriptive the first time...

 

[JVFriederick]

Once you pick LIST, there will appear a SOURCE range. Use the SOURCE boxto refer to the list you have created.

Ugghh. So many of the same words to describe different things........

 

[dmccallum]

My list was maintained on another sheet but I found if I defined a range on the same sheet as the checkbook that referenced the the list I was then able to enter the newly defined range in the Source box and it works great!

Thanks!

 

[JVFriederick]

Good for you.

I suspect you'll be validating more than just "descriptions" soon . . . . . . .