• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display Part of Excel on VBA Form

nagovind

nagovind

Member
Please advise how to Display Part of Excel on VBA Form
I have range of data in A1:F10
While running a macro how to display selected ranges of cells in an userform as a pop-up (Say selected data is A1:C10)
Please do the needful
Thanks
Govind
 
This code is working for me
(taken from example worksheet from other thread by HUI -> Sample_file_pk_Hui.xlsm

Code: 
Sub preview()
  UserForm1.ListBox1.ColumnCount = 5
  UserForm1.ListBox1.List = Worksheets("Sheet1").Range("A1:E10").Value
  UserForm1.Show
End Sub
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top