Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get row number using input box
I need to get the row number from a sheet by using an input box
type = 8 ? Once I have the row it will be used to copy selected columns to another sheet. Right now I' using this: Sheets("Tickler").Select myvar = Application.InputBox("Enter Line number to retrieve Row", "OPTIONS", _ Type:=1) Range(Cells(myvar, 16), Cells(myvar, 22)).Select Selection.Copy .... AH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get row number using input box
I text box returns a string and you need a number
from Range(Cells(myvar, 16), Cells(myvar, 22)).Select Selection.Copy to Range(Cells(val(myvar), "P"), Cells(val(myvar), "V")).Select Selection.Copy "Allan" wrote: I need to get the row number from a sheet by using an input box type = 8 ? Once I have the row it will be used to copy selected columns to another sheet. Right now I' using this: Sheets("Tickler").Select myvar = Application.InputBox("Enter Line number to retrieve Row", "OPTIONS", _ Type:=1) Range(Cells(myvar, 16), Cells(myvar, 22)).Select Selection.Copy ... AH |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get row number using input box
Type 8 is useful if you want the user to do the selection with the mouse
rather than the keyboard: Sub dural() Dim r As Range, s As String s = "select cells to copy with mouse " Set r = Application.InputBox(s, Type:=8) r.Select Selection.Copy End Sub -- Gary''s Student - gsnu200747 "Allan" wrote: I need to get the row number from a sheet by using an input box type = 8 ? Once I have the row it will be used to copy selected columns to another sheet. Right now I' using this: Sheets("Tickler").Select myvar = Application.InputBox("Enter Line number to retrieve Row", "OPTIONS", _ Type:=1) Range(Cells(myvar, 16), Cells(myvar, 22)).Select Selection.Copy ... AH |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get row number using input box
Thanks, using the mouse option was just what I was looking for.
-- AH "Gary''s Student" wrote: Type 8 is useful if you want the user to do the selection with the mouse rather than the keyboard: Sub dural() Dim r As Range, s As String s = "select cells to copy with mouse " Set r = Application.InputBox(s, Type:=8) r.Select Selection.Copy End Sub -- Gary''s Student - gsnu200747 "Allan" wrote: I need to get the row number from a sheet by using an input box type = 8 ? Once I have the row it will be used to copy selected columns to another sheet. Right now I' using this: Sheets("Tickler").Select myvar = Application.InputBox("Enter Line number to retrieve Row", "OPTIONS", _ Type:=1) Range(Cells(myvar, 16), Cells(myvar, 22)).Select Selection.Copy ... AH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
number input | New Users to Excel | |||
number input box | Excel Worksheet Functions | |||
User Input Of A Number | Excel Programming | |||
making a cell fixed number to a input number | Excel Programming |