UserForm & ListBox Problem

**hifliers** · 05-11-2009, 06:15 AM

Dear Masters of Excel,

Please see attached file.
I am making planning & status board for each project(yard). But in my 1st Stage I am having a problem for creation of Userform & List Box for my Display Sheet.

Problem-1) I want to create userform which can Add or Delete my MasterData.

Problem-2) I want to display & change Block Status of Yard in List View. Yard No will be selected using combo box.
List View Should allow addition & Deletion of record.

Note: I am a bit new user for VBA but can copy codes from sample file to use in the files.

Any help on this will do a great help for my project

Thanks in advance.

Vishnu

**royUK** · 05-11-2009, 06:44 AM

Your master data is split into 3 blocks by the empty columns, is there a reason for this?

What do you mean by List view?

**hifliers** · 05-11-2009, 07:04 AM

Dear Roy,

Thanks for your quick reply..

It's a three table.. It can be separated into three different Sheet.

List View is List Box..

Regards,

Vishnu

**royUK** · 05-11-2009, 07:07 AM

So do you want a listbox for each table?

**hifliers** · 05-11-2009, 08:04 AM

can you give two sample files.

1) Userform to add,modify or delete Data.
2) Listbox dependent on Value seleted on dropdoen box.

Regards,

Vishnu

**royUK** · 05-11-2009, 08:16 AM

1) Userform to add,modify or delete Data.

DataBaseFormAmended.zip

2) Listbox dependent on Value seleted on dropdoen box.

DependantlistBoxes.zip

**hifliers** · 05-11-2009, 08:45 AM

Dear Roy,

Thanks.. Your Example File Data Entry is just what I wanted.

For List Box I have a Data Like That

Clm A ClmB Clm C Clm D
Vishnu 25 26 56
Roy 51 57 59
Vishnu 00 02 10
Roy 25 35 41

Now I will Put Combobox Above my listBox. & I will Select Roy to see Only values related to roy in ListBox.

Please send me example like that.

Regards,
Vishnu

**royUK** · 05-11-2009, 08:51 AM

Have a loo at this

Filter-ListBox.zip

**hifliers** · 05-12-2009, 06:50 AM

Dear Roy,

Thanks A Lot for your Sample File.

Based on Your Sample File I Have made a form. please check attached file.
Now I want to add a command Button which will add,modify or Delete entry in listbox1.

Please suggest procedure or send a sample file

Regards,

Vishnu