471,350 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

Excel : how to find corresponding constants name in vb . net ?

Hello,
I'm currentry porting a vba project into vb .net
Things are going smoothly for the moment, but I'm loosing a lot of time to
find the counterparts constants name for ex :
ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
can I find the corresponding constant in vb.net ?
Many thanks
Jul 21 '05 #1
3 5012
Another ex :
With ThisApplication.Selection.Validation
.Delete()
.Add(Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=Remarks")

xlValidateList, xlValidAlertStop, xlBetween ????

I have tried to search those with excel.Constants which give constants name
but not able to find ....

"François" wrote:
Hello,
I'm currentry porting a vba project into vb .net
Things are going smoothly for the moment, but I'm loosing a lot of time to
find the counterparts constants name for ex :
ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
can I find the corresponding constant in vb.net ?
Many thanks

Jul 21 '05 #2
On Fri, 4 Mar 2005 04:51:01 -0800, Franois <Fr*****@discussions.microsoft.com> wrote:

Hello,
I'm currentry porting a vba project into vb .net
Things are going smoothly for the moment, but I'm loosing a lot of time to
find the counterparts constants name for ex :
ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
can I find the corresponding constant in vb.net ?
Many thanks

Have you looked in the Object Browser for Microsoft.Office.Interop.Excel.Constants?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Jul 21 '05 #3
Yes, finally it seems that it is the only solution. Missing a find like 'in
vba' to be quicker ....

Thanks for your answer.

"Paul Clement" wrote:
On Fri, 4 Mar 2005 04:51:01 -0800, François <Fr*****@discussions.microsoft.com> wrote:

¤ Hello,
¤ I'm currentry porting a vba project into vb .net
¤ Things are going smoothly for the moment, but I'm loosing a lot of time to
¤ find the counterparts constants name for ex :
¤ ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
¤ can I find the corresponding constant in vb.net ?
¤ Many thanks

Have you looked in the Object Browser for Microsoft.Office.Interop.Excel.Constants?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
2 posts views Thread by Agoston Bejo | last post: by
1 post views Thread by Boomessh | last post: by
3 posts views Thread by implicate_order | last post: by
3 posts views Thread by Lance Hoffmeyer | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
1 post views Thread by Ally | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.