ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
On my worksheet in a column I apply the word POSTED.
Once the item has been delivered the POSTED is replaced with the date.
Sometimes there are non deliveries & others so POSTED is replaced with LOST & other words.
After a few months I open the userform which at present only has Listbox1
The Listbox is populated with all the issues mentioned from that column
Example.
LOST
RETURNED
DELIVERED NO SIGNATURE
I wish to now have some guidance as to say having a checkbox or other next to each customer in the List where it shows LOST RETURNED etc etc.
So at a glance the user can see which have the check in the checkbox applied.
Is this possible or must I do this on the worksheet itself ?
I was hoping that wasn’t the way it’s to be done as it would mess things up for me so I thought userform would be the way forward.
Once the item has been delivered the POSTED is replaced with the date.
Sometimes there are non deliveries & others so POSTED is replaced with LOST & other words.
After a few months I open the userform which at present only has Listbox1
The Listbox is populated with all the issues mentioned from that column
Example.
LOST
RETURNED
DELIVERED NO SIGNATURE
I wish to now have some guidance as to say having a checkbox or other next to each customer in the List where it shows LOST RETURNED etc etc.
So at a glance the user can see which have the check in the checkbox applied.
Is this possible or must I do this on the worksheet itself ?
I was hoping that wasn’t the way it’s to be done as it would mess things up for me so I thought userform would be the way forward.