Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Input Box

Status
Not open for further replies.
braven

braven

Programmer
May 20, 2009
58
CA
how do i enter inputbox like fiscal year and perid
exampleUserInput = InputBox ("FISCAL YR 2009 PER 08 "
but it changes year and period
is it somthing "FISCAL YR (YR) PER (n+1)
 
Sort by date Sort by votes
i found in this website.
now i have another issue
USERINPUT = INPUTBOX ('ENTER PERIOD')
how to do F 'FISCAL YR(YEAR(NOW)PER USERINPUT'
i tired
Myscreen.sendkeys("F ")
Myscreen.sendkeys(''FISCAL YR(YEAR(NOW)PER USERINPUT'
)
it gives syntax errror.
 
Upvote 0 Downvote
please anyone help me the below one
MyScreen.SendKeys("F")
MyScreen.SendKeys("'" + "FISCAL YR"+MyYear + "per" + UserInput + "'")
i need space befwwe Myyear and per and space between per and userinput
userinput = Input("enter period")
Myyear = year(now())
it sends F 'FISCAL YR2009PER09
 
Upvote 0 Downvote
i found out from this website
this is the right one
MyScreen.SendKeys(" '" + " FISCAL YR "+ +MyYear + " PER " + UserInput + "'")
thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Daemon11
  • Locked
  • Question
The message "No Input field was found in row >" is not clear
Replies
0
Views
153
Daemon11
Daemon11
DustoBOE
  • Locked
  • Question
Input box cancel button to stop macro?
Replies
3
Views
81
DustoBOE
DustoBOE
rob7785
  • Locked
  • Helpful tip
Attachmate msg box not working In VB code 1
Replies
7
Views
96
rob7785
rob7785
tedb13
  • Locked
  • Question
creating a user input dialogbox...word wrap
Replies
2
Views
69
tedb13
tedb13
scottian
  • Locked
  • Question
Info Box
Replies
0
Views
35
scottian
scottian

Part and Inventory Search

Sponsor

Back
Top