Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox value as sourcerange
Hi
Can I use a textbox value as sourcerange? If so, how do i go about (I only get this far); Set SourceRange = Range(TextBox1).Value Again many thanks Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox value as sourcerange
If Textbox1 contains a valid cell address such as A1 or $A$1 ; you can as below
Dim SourceRange as Range Set SourceRange = Range(Cstr(TextBox1)) 'Msgbox SourceRange.Address If this post helps click Yes --------------- Jacob Skaria "Basta1980" wrote: Hi Can I use a textbox value as sourcerange? If so, how do i go about (I only get this far); Set SourceRange = Range(TextBox1).Value Again many thanks Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set sourceRange | Excel Programming | |||
Is there a "Set sourceRange =" for all sheets in workbook | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming |