Select range for a Ref in the user form.

Hi,

My question is - for a Ref range in the user form, I want to set it up to only be able select from column A B and C. ( it has select ABC column at the same time, if missing any column, error message will come out, or select out of this range, the error message should also come up. )

I know how to set the range to all three columns, but I know don't how to ask for " must select from all three column?"

Thank you in advance for any help. !!

Hi, Thanks for you reply!

I tried it in my VBA, and it turn out the error " object doesn't support this property or method"
My code is

If refDataRange.Columns.Count <> 3 Then
MsgBox (" Please select range from all A,B and C columns")
End If

Originally Posted by nathansav

if your range is called refRange

then

if refRange.columns.count <> 3 then
msgbox "3 columns are needed in this function"
end if