How can i upload values of Non-Empty Cells Reference of a Table in ComboBox

		Microsoft Office Forums > Microsoft Word > Word VBA
How can i upload values of Non-Empty Cells Reference of a Table in ComboBox

FAQ

Thread Tools

Display Modes

03-08-2021, 04:53 AM

gmayor

Windows 10 How can i upload values of Non-Empty Cells Reference of a Table in ComboBox

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,137

If you want the empty cells listing then

Code:

For i = 1 To .Cells.Count
            If Len(.Cells(i).Range) = 2 Then
                ComboBox1.AddItem .Cells(i).RowIndex & ", " & .Cells(i).ColumnIndex
            End If
Next i

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to SUM the values only if the particular cells are not empty?	Learner7	Excel	3	11-10-2020 02:47 AM
auto progress number evenly between two values across empty cells ?	DBenz	Excel	4	03-28-2018 04:46 AM
If a2 is not empty, color empty cells in b2:af2	turkanet	Excel	2	08-20-2017 11:00 PM
Microsoft Excel 12.0 Object Library reference upload	chamdan	Project	2	04-21-2014 06:30 AM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.