Console in Visual Basic Excel - How do i make one?

[persson121]

Hi

I have made a macro who creates a graph to me.
The code look like this:

Please Login or Register  to view this content.

I want to make a console, just a basic one. The console is gonna ask me what function i want to run. I'd press for example Nr 3 and the console run function number 3. Then the console ask agin. Just like a loop. But i don't realy know how im gonna do the loop.


The code above will not be a sub(). I will be a Function().
The loop main function will be a sub()

[GaidenFocus]

I can show you how to make one in UserForms, but it is a seperate pop up menu type thing. I got from your post that you are trying to do this in the sheet itself?

[persson121]

I can show you how to make one in UserForms, but it is a seperate pop up menu type thing. I got from your post that you are trying to do this in the sheet itself?

Userforms is good, but to hard for me.
But is it possible to call a "MS-dos" window and it says "hello. What do you want?" in VBA/Excel?

[GaidenFocus]

You could do a MsgBox

Please Login or Register  to view this content.

[royUK]

Why do you think that you want a Function not a sub?

[persson121]

You could do a MsgBox

Please Login or Register  to view this content.

Can i not use a console?

[royUK]

What do you mean by a console, the only other thing would be a UserForm

[persson121]

What do you mean by a console, the only other thing would be a UserForm

Are you serious?
Don't you know what console is?

Think about C++. Can visual basic make a popup console?

I get debug problem when i trying to run this:
Sub hello()
Console.WriteLine ("Please enter a grade")
End sub()

[shg]

Are you serious? Don't you know what console is?

Console is not an Excel/VBA concept; this is an Excel/VBA forum.

You could use the InputBox function.

[royUK]

Answering questions with your attitude is the best way not to get help.

If you were asking for a console in a different programming forum it would make sense. You are using VBA so are restricted to available tools, your responses to valid suggestions such as message boxes & userforms highlights your lack of knowledge.

[jeffreybrown]

@ persson121,

Your post does not comply with Rule 6 of our Forum RULES. Common courtesy is the order of the day.

This is a free forum where members provide feedback to the questions you propose. If we are not entirely clear on your intended direction, please take the time to help us help you by providing clearer direction.

Two of the members who have responded are seasoned professional on forum's like this and I would make every attempt not to alleniate the free help you are being provided.

Please also consider adjusting your profile location to something a little more sensible.