About "EXCEL6" Window Class ?

[halim]

Hi All,
What is Window class "EXCEL6" in Excel used for ?

Need help urgent ... please !

Regards,

Halim

[RB Smissaert]

It is the window of the worksheet cell that is in edit mode.
What do you need it for? Probably easier to get or set information
via the Excel object model than via the API.

RBS

"halim" <hni@cmwi.co.id> wrote in message
news:1152937158.298397.146880@s13g2000cwa.googlegroups.com...
> Hi All,
> What is Window class "EXCEL6" in Excel used for ?
>
> Need help urgent ... please !
>
> Regards,
>
> Halim
>

[halimnurikhwan@yahoo.com]

Thank you very much for reply me..
But can we release each cell in a worksheet

so it will be shown as window with the caption

so I can refer Userform1.left to cell.left as we see in the screen

Rgds,

halim

RB Smissaert menuliskan:
> It is the window of the worksheet cell that is in edit mode.
> What do you need it for? Probably easier to get or set information
> via the Excel object model than via the API.
>
> RBS
>
> "halim" <hni@cmwi.co.id> wrote in message
> news:1152937158.298397.146880@s13g2000cwa.googlegroups.com...
> > Hi All,
> > What is Window class "EXCEL6" in Excel used for ?
> >
> > Need help urgent ... please !
> >
> > Regards,
> >
> > Halim
> >

[RB Smissaert]

Not sure I understand, but how about:
Userform1.Left = Cells(5, 2)

Keep in mind that VBA code can't run when a cell is in edit mode.

RBS

<halimnurikhwan@yahoo.com> wrote in message
news:1152953109.529298.37760@m79g2000cwm.googlegroups.com...
> Thank you very much for reply me..
> But can we release each cell in a worksheet
>
> so it will be shown as window with the caption
>
> so I can refer Userform1.left to cell.left as we see in the screen
>
> Rgds,
>
> halim
>
> RB Smissaert menuliskan:
>> It is the window of the worksheet cell that is in edit mode.
>> What do you need it for? Probably easier to get or set information
>> via the Excel object model than via the API.
>>
>> RBS
>>
>> "halim" <hni@cmwi.co.id> wrote in message
>> news:1152937158.298397.146880@s13g2000cwa.googlegroups.com...
>> > Hi All,
>> > What is Window class "EXCEL6" in Excel used for ?
>> >
>> > Need help urgent ... please !
>> >
>> > Regards,
>> >
>> > Halim
>> >
>