i need you help becuase i am kind of stuck for now.
i am designing a macro in excel using VBA and i have put in a few codes for now.
i just want to know how is it possible to "code" the command button so that when clicked on, the windows explorer(just like when you have to open a file in microsoft word) will appear so that the user can select the file to be opened and once the user selects the file and clicks open, the result will appear in the textbox next to the button. but i dont want the file to be opened. i just want the result(path) of the file to appear in the textbox.
this is because i have another button at the bottom of the macro that would run all the selected files at the end because there is actually 3 command buttons and 3 textboxes that i need to "collaborate" at the end.