XlBorderWeight enumeration

[lezawang]

Hi
I wanted to assign value to this line

    Workbooks(1).Worksheets(1).Cells(xrow, xcol).Borders.Weight =

So I used Object Browser, and typed Borders then clicked on weight and I read the following:

Property Weight As Variant

Property Weight As Variant that is all! nothing else.

I had to google it and found that:

Borders.weight "[FONT=&quot]Returns or sets an [/FONT][FONT=&quot]XlBorderWeight[/FONT][FONT=&quot] value that represents the weight of the border."

[/FONT]Then I went back to vba Object browser and typed XlBorderWeight to find all values. Is that the way how to find what the values I need to pass to Borders.weight? Why Object Browser does it tell me Weight values are in XLBordersWeight?

How can I or someone link Weight with XlBorderWeight?

Same apply with Borders.Style and XlLineStyle

Thank you so much.

 

[dmt32]

Hi,
should find answer in VBA helpfile

https://docs.microsoft.com/en-us/do...e.interop.excel.xlborderweight?view=excel-pia
which shows members & their values.

You can use XLBorderWeight Enum in you code

Dim BorderWeight As XlBorderWeight


BorderWeight = xlHairline

you will find when you place = sign after the variable that you will be presented with the intelliSense showing the List Members

Should be able to do same for XlLineStyle Enum


Hope Helpful

Dave

 

[lezawang]

"you will find when you place = sign after the variable that you will be presented with the intelliSense showing the List Members"

Thanks for your reply but that is not happening?
Do I need to do anything with the setting so I can see these options once I type =
Thank you once again

 

[Fluff]

In the VbE goto Tools > options & make sure that both "Auto list members" and "Auto quick info" are checked.

 

[lezawang]

Thank you. They both checked but still noting comes up. When I type this code

workbooks(1).worksheets(1).cells(1,1).borders.weight =

only after typing workbooks(1).
I get a list of option but then when I continue typing nothing will come after worksheets(1). and nothing after cells(1,1). and nothing after borders. and nothing after weight=

Thank you

 

[Fluff]

No they wont, but if you used the code that dmt32 provided, you would have got the intellisense.

 

[shg]

I get a list of option but then when I continue typing nothing will come after worksheets(1)

There are a lot of syntaxes that don't support Intellisense, and Worksheets() is one. That one I understand, because Worksheets can return a single sheet with all the usual properties and methods, or an array of sheets which have different P&Ms (e.g. FillAcrossSheets). If you used a worksheet variable, Intellisense would appear.

Intellisense works for Range(), not for Rows() and Columns(); not sure why, but haven't thought hard about it.

 

[lezawang]

Thank you, but my point how is how can I know border.weight takes one of XlBorderWeight values?
Ok these days I can do google search but lets say and I think Excel/VBA is way before the Internet.
Lets say I am in 1990 and I want to write this code

 workbooks(1).worksheets(1).cells(1,1).borders.weight =

Now I stuck here and I want to know what value I should write?

how can I know when Object Browser is not telling me anything and I do not have Internet to google? and possibly this site was not existed. Thank you very much.

 

[shg]

In Help for Borders.Weight,

Borders.Weight Property
Returns or sets a XlBorderWeight value that represents the weight of the border.

... and xlBorderWeight is hyperlinked to the enumeration values.