Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning VBA results to a cell
Ok, if anybody read my last post you would know that I am a newbie at
this VBA Stuff. So this question is probably gonna be obvious to most people...I however have no clue. I have written some code that comes up with a form with textbox for a value...I want that value be exported to a cell somewhere on one of my worksheets. I have figured out how to make a cell active but I can not figure out how to get it to write a variable or return a fuction to a cell....any help would be greatly appreciated as always.. Thank You, Jason Self --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning VBA results to a cell
Just put the text value in the cell, you don't need to make the cell active,
like so Worksheets("Sheet1").Range("A1").Value = Textbox1.Text -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "JasonSelf " wrote in message ... Ok, if anybody read my last post you would know that I am a newbie at this VBA Stuff. So this question is probably gonna be obvious to most people...I however have no clue. I have written some code that comes up with a form with textbox for a value...I want that value be exported to a cell somewhere on one of my worksheets. I have figured out how to make a cell active but I can not figure out how to get it to write a variable or return a fuction to a cell....any help would be greatly appreciated as always.. Thank You, Jason Self --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning VBA results to a cell
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Desired Results | Excel Discussion (Misc queries) | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
Sumproduct not returning expected results | Excel Worksheet Functions | |||
Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) | |||
Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) |