View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Code to add comments to selected cells within a selected range

On Tuesday, January 28, 2014 10:43:06 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Tue, 28 Jan 2014 10:37:13 -0800 (PST) schrieb L. Howard:



I have used them very little, in fact I don't even know how to change the Test 1, Test 2 etc. to something more meaningful.




the rowSource for the ListBox is L1:L5 in sheet1.

You can change the values in that range and can change the RowSource

into the properties of the ListBox.





Regards

Claus B.

To access the property window of the userform or any of the controls you put on the userform don't you just Right Click that item. I also see f4 should access the property windows.

None of that happens for me.

I am using a HP Pavilion g series lap top and to use the f-numbers there is a key (w/ Microsoft Logo) that acts like the shift key does, to access the 'upper case' f functions.

Upper case f4 on cell address make works for relative or absolute but does not access the properties in the vb editor.

Any suggestions?

Howard