Questions on sheets and Input box comand

  • Thread starter Thread starter Marcus Pedersén
  • Start date Start date
M

Marcus Pedersén

Hi!
I have a couple of questions that I hope someone can help me with.
Question one: The "buttons" at the bottom in Excel that you press on to go
between the different sheets, is it possible to hide them? And how do you do
that then? (Cos I have made "linking" buttons on the sheets that makes it
look nicer and I want the user to use these instead and therefor hide the
"standard buttons").
Question two: I have made a macro with an Inputbox and then depenting on
value inserted sort and make different actions but: If I want the value that
is inserted in the Inputbox to be inserted in a specific square, what is the
camand for that? And how do I do that? Is it possible to make "multiple
Inputboxes" with many different inputfields on the same "pop-up window" and
how do I make the different values end up in separate squares? Comands?

Please help me!

Many, many thanks in advance!!

Marcus
 
Marcus,

Question one. Tools - Options - View - Worksheet tabs.

Question two Range("A
If I want the value that
is inserted in the Inputbox to be inserted in a specific square, what is the
camand for that?

Range("A5") = Inputbox(etc)
Is it possible to make "multiple
Inputboxes" with many different inputfields on the same "pop-up window"

It's called a UserForm, which you make in the VBE. It's a bit involved for
a newsgroup reply. Get a book on Excel macros.
and
how do I make the different values end up in separate squares? Comands?

Macros that respond to the userform.
 
Back
Top