Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Hi,
Help sorely needed. Been researching and trying to set up my own userform but always keep getting stuck. Seen some good examples of bits and bobs of what I need but when I try to cater them for what I need they never work and I can't solve why they won't work. What I have is this:- One sheet in my workbook is called 'Subs Targets'. On this sheet I have many columns with data. On my userform the first drown box I have is for Editor selection. This is equal to column B. This has many of the editors names repeated and I only want singular names (no repears). This first drop down drives the second drop down selection. This colum is equal to column D and again has repeating items in it for which I only want to have the individual titles (no repeats) displayed in the drop down. Then once you choose from the second drop down I would like an editable list to be displayed showing the values of columns J to AD, but only columns O,T,Y and AD being editable. The others being fixed. If the user edits the data in either O.T, Y and AD then this replaces the existing data in the relevant cell. I am really struggling and would greatly appreciate any sort of help Many Thanks Matthew Balch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |