| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write Data from Control on a Windows Form
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write Data from Control on a Windows Form
Ted
It basically looks like this ActiveCell.Value = Userform1.Combobox1.Text ActiveCell.Value = Userform1.Textbox1.Text -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ted" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write Data from Control on a Windows Form
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" wrote: Ted It basically looks like this ActiveCell.Value = Userform1.Combobox1.Text ActiveCell.Value = Userform1.Textbox1.Text -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ted" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write Data from Control on a Windows Form
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. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ted" wrote in message ... 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" wrote: Ted It basically looks like this ActiveCell.Value = Userform1.Combobox1.Text ActiveCell.Value = Userform1.Textbox1.Text -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ted" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| Write data back from a form to sheet | Excel Discussion (Misc queries) | |||
| Windows - Delayed Write Failed | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
Hybrid Mode
