Write Data from Control on a Windows Form

[Guest]

Would someone tell me how to write data from a text or combo box on a Windows
Form to the Active Cell in an Excel spreadsheet?

 

[Dick Kusleika]

Ted

It basically looks like this

ActiveCell.Value = Userform1.Combobox1.Text
ActiveCell.Value = Userform1.Textbox1.Text

 

[Guest]

Dick,
Thanks, it looks like it worked fine in VBA. Just 1 other question? I
am unable to reference the ActiveCell in .Net (VS Tools for Office). Which
has led me to try something like the following... Dim intRange As Excel.Range
= Me.thisWorksheet.Range("ActiveCell").
Would you know how I could reference the Active Cell in .Net? so that I
can write from the Windows Form to the Cell and recieve from the Cell back to
the Form?
Ted

 

[Dick Kusleika]

Ted

I don't know. If you ask in microsoft.public.vsnet.vstools.office I'll bet
you'll get an answer. I'll bet its

Me.thisWorksheet.Activecell

but you should really ask the experts.