My listbox will only display Column B to Column F and not Column A even
though I have set my RowSource to "Sheet1!A1:F10".

Where did I go wrong? Please help

Are you not using a microsoft forms list box from the control toolbox?
in which case it should be a list fill range rather than row source being
set to a1:f10

"Francis Ang" wrote:

My listbox will only display Column B to Column F and not Column A even
though I have set my RowSource to "Sheet1!A1:F10".

Where did I go wrong? Please help

Did you change the .columnwidths property?

Did you have a horizontal scrollbar that you can scroll to the left?

Is this listbox on a userform on placed on a worksheet?

Francis Ang wrote:

My listbox will only display Column B to Column F and not Column A even
though I have set my RowSource to "Sheet1!A1:F10".

Where did I go wrong? Please help

--

Dave Peterson

Thank you Dave. You were right. It was the .columnwidths setting.

"Dave Peterson" wrote:

Did you change the .columnwidths property?

Did you have a horizontal scrollbar that you can scroll to the left?

Is this listbox on a userform on placed on a worksheet?

Francis Ang wrote:

My listbox will only display Column B to Column F and not Column A even
though I have set my RowSource to "Sheet1!A1:F10".

Where did I go wrong? Please help

--

Dave Peterson