asked on

vba query

Hi ,
i would like to know for my attached excel , is there a way i can make it menu based .

1 . Serial Number i would like to go in sequence starts from 1
2. Brand , i should select from pull down ( not in excel ) but in menu format
3. Multi type selection i need to get it from menu .

if you can give me ideas, it would be great for me start of with the project .

Cheers,
Sid
Test1-Menu-VBA.xlsx

Daniel Pineault

What about applying a filter? Simply select Row 2 and select Filter (Home->Sort & Filter->Filter). Now you can sort and/or filter based on any column.
As for sequential numbering, you can make it equation based, so 1 for the first value in B3m but after that =B3+1 and apply that downwards as required.

Your other choice would be to create a UserForm, use VBA automation ,,, but this is likely to become complex quickly.
Test1-Menu-VBA_02xlsx.xlsx

infiniti7181

ASKER

Hello Daniel,

Thanks for the response . Basically the objective is to create a CRM sort of a tool where i will have multiple entries that can reach 1000+ cells . So instead scrolling through cells for entry, i can use form based system and retrieve through form / menu based system .

I am not sure , if this solution is achievable through VBA

Regards,
Sid

ASKER CERTIFIED SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Daniel Pineault

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial