I currently have an Input Box and a List Box on a worksheet that I wish to be linked. The plan is that I have the input box (that contains a list of values) and the user selects one of those values. However, then this value should be linked to a list box so when they select the date, it selects that date in the list box as well.
I'm unsure on how to do this though, so any pointers would be appreciated.
from reading your post, I get that you don't actually want the user to be able to input anything of their own, but merely select one of several values? But that can't be what you actually want because in that case, what would be the difference to just adding a field to the GUI for the user to select on?
I'm quite sure I must have misunderstood that - can you put it a bit more precisely, please?
P.S.: The more precise you put it, the better the chances of getting help quickly - and the precise formulation of your problem might even lead you to a possible solution as happens to me quite often ...
I currently have a list box that the user selects the Month-Year from,using Date(Date_Entered, 'MMM-YY'), but now I want it to be an input box using a variable called vStartDate and one called vEndDate. I have selected a couple of start and end dates, but as I still have the MonthYear column shown on screen it doesn't select these values. Is there a way of seeing these values selected so I can be sure it works correctly. The plan is to get rid of the list box once this works.