In this article, you will learn how to increase the size of the selected cell that contains data validation.
If you are working on a report that contains too much information & there is shortage of space, the cells that contain data validation with too much information will not be visible.
Question): Column A contains data validation & the problem I am facing is the width of the cell is only five and when I try to select the selection from the dropdown list, the whole content is not visible.
How can I view the entire information visible to the user when selecting the data validation cell?
Snapshot of data contains data validation cell wherein the content is too large. Refer below snapshot:
We need follow the below steps:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 Then
Target.Columns.ColumnWidth = 30
Columns(1).ColumnWidth = 5
In this way, we can increase the width of the data validation of the cell upon selection using Macro.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.