Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Any VBA guru's?


  • Please log in to reply

#1
Geeves

Geeves

    Member

  • Member
  • PipPip
  • 18 posts
I have been working on macros for our mainframe interface system here at my job for a little over a week now. I have them working just fine but I wanted to put a few tweaks in them to remove as much user interacton as possible.

It has be a long time since I've done VB, and I have never done VBA so I'm pretty much just fumbling blindly until I get the code to work.

I know how to use the InputBox() and PasswordBox() for single strings/entries.

What I would like to know if if there is a way to have a popup of selections that will pop up automatically.

Example:

Input box for the user's ID
PasswordBox for the password
List Box displaying a selection of systems to log into

For the list box I would prefer radio buttons or a drop down menu of some sort and it would save the selection in a variable. Thus stopping the user from having to type almost anything except for the Operator ID they need to access.

Anyone know how to do this?
  • 0

Advertisements


#2
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
i know how u are feeling
had to do sorta the same thing
u are using VBA? or VB?
There is a way by creating forms in VBA (found in Excel or Word, or Access)
if u are using VBA id say never create the forms yourself. If u are accessing say excel from word and telling it to run a maco in excel, the form u want put up is never displayed(only fer 1 sec) u can never interact with it.

all i had to use was the popup forms(of course i was a co-op student from highschool) gr11 working fer high end telephone company. so maybe there are other ways so i am not master lol
  • 0

#3
Geeves

Geeves

    Member

  • Topic Starter
  • Member
  • PipPip
  • 18 posts
I guess it's a form of VBA. It's 100% script so I don't get to actually create the form as in VB. It's not a MS application. We use an app called Attachmate EXTRA. It's an interfrace for our mainframe apps. The code is very similar to VBA from what I can make out.

Like I said I'm looking for a way to create a pop up list of some sort for the users to choose from. The choice would then be saved into a var for later use in the macro. I could always do it via IF statements but thats not very efficient.......


:tazz:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP