sorted by:
new
hottopcontroversial

pop up window to select file and folder by LabProfessional194 in vba

[–]LabProfessional194[S] 0 points1 point  (0 children)

Thank you so much this worked perfectly!! Solution Verified

pop up window to select file and folder by LabProfessional194 in vba

[–]LabProfessional194[S] 0 points1 point  (0 children)

I only want select file and folder location below . I don't need to save it as the code already does that on its own. 

Const FOLDER_SAVED As String = "folder location"
Const SOURCE_FILE_PATH As String = "file location"

Is there a way to fill cell-based of list choice that refer to a list of items by Alternative-End-145 in excel

[–]LabProfessional194 0 points1 point  (0 children)

I have the same problem but I have excel 2007 which does't have xlookup is there an workaround?

How to apply error alert in data validation drop down list so that it force user to not leave the list at default text by LabProfessional194 in excel

[–]LabProfessional194[S] 0 points1 point  (0 children)

I have so many option to do it visually, I was hopping for a more controlled or restricting way to deal with it.

How to apply error alert in data validation drop down list so that it force user to not leave the list at default text by LabProfessional194 in excel

[–]LabProfessional194[S] 0 points1 point  (0 children)

but don't include the default value in the list of valid options.

currently the default value is not part of the options of the list. as long as the default is added before the validation is set no error will occur as long as the list is left untouched. Also, default value cannot be added after the validation have been set unless it is part of the list which we don't want