Hi,

I'm sure this is a fairly simple question but I don't seem to be able to find a way of acheiving the result I'm after:

I have a macro the accesses a number of files and reformats the data within them. The path specified within the macro has a value in it which I would like to make a variable.

I would then like to update these variable using a list box in a seperate worksheet. The user needs to be able to choose from a selection of userids and the choice then needs to update the path within the specified macro.

Can anyone tell me how to

A. Create the List Box and update with the necessary id's.
B. Amend the macro so that the required part of the file path accepts the value passed from the List Box.

Many thanks