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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 ....
 
¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Yes, finally it seems that it is the only solution. Missing a find like 'in
vba' to be quicker ....

Thanks for your answer.
 
Back
Top