VBA: User selects a column

[JMK326]

Each month we receive an updated budget which includes info for every month of the budget year. I want the user to be able to select the column (which relates to a month) that they want to use for the analysis. I will use the data in this column only for analysis. How can I do that?

Thank you!

 

[Smitty]

Welcome to the Board!

It's not entirely clear what you're trying to do. What should happen after a user selects a column?

 

[JoeMo]

Use the Application.InputBox Method, see VBA Help for a description of the method and examples of its application.

 

[JMK326]

Thank you! I got it.