Insert Listbox in Essbase Form
 

I have created a form in Visual Basic and for the life of me I cannot figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks

Insert Listbox in Essbase Form
 

Not too sure what you are looking for or how it relates to Essbase but here
goes... I assume that we are discussing a userform. I assume that you have a
userform created (Insert - UserForm). You now have a blank userform on the
screen. If your toolbox is not visible then select View - Toolbox. Now you
can just drag a text box or combo box directly onto the form...if the problem
deals with Essbase somehow just let me know...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have created a form in Visual Basic and for the life of me I cannot figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks

Insert Listbox in Essbase Form
 

OK thanks Jim, for some unknown reason I couldn't view the toolbox, Can I
type my own values in the control source or do I have to reference a range of
cells on a worksheet

I tried the following but it din't like it as the control source

sheets.lists.range("a1:a6")



"Jim Thomlinson" wrote:

Not too sure what you are looking for or how it relates to Essbase but here
goes... I assume that we are discussing a userform. I assume that you have a
userform created (Insert - UserForm). You now have a blank userform on the
screen. If your toolbox is not visible then select View - Toolbox. Now you
can just drag a text box or combo box directly onto the form...if the problem
deals with Essbase somehow just let me know...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have created a form in Visual Basic and for the life of me I cannot figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks

Insert Listbox in Essbase Form
 

sheet1!A1:A6

where sheet1 represents the tab name.

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
OK thanks Jim, for some unknown reason I couldn't view the toolbox, Can I
type my own values in the control source or do I have to reference a range
of
cells on a worksheet

I tried the following but it din't like it as the control source

sheets.lists.range("a1:a6")



"Jim Thomlinson" wrote:

Not too sure what you are looking for or how it relates to Essbase but
here
goes... I assume that we are discussing a userform. I assume that you
have a
userform created (Insert - UserForm). You now have a blank userform on
the
screen. If your toolbox is not visible then select View - Toolbox. Now
you
can just drag a text box or combo box directly onto the form...if the
problem
deals with Essbase somehow just let me know...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have created a form in Visual Basic and for the life of me I cannot
figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks

Insert Listbox in Essbase Form
 

THanks, I found that eventually, the help file is not much help at all, I do
have one other question tho is it possible to manually enter values into the
row source

Thanks


"Tom Ogilvy" wrote:

sheet1!A1:A6

where sheet1 represents the tab name.

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
OK thanks Jim, for some unknown reason I couldn't view the toolbox, Can I
type my own values in the control source or do I have to reference a range
of
cells on a worksheet

I tried the following but it din't like it as the control source

sheets.lists.range("a1:a6")



"Jim Thomlinson" wrote:

Not too sure what you are looking for or how it relates to Essbase but
here
goes... I assume that we are discussing a userform. I assume that you
have a
userform created (Insert - UserForm). You now have a blank userform on
the
screen. If your toolbox is not visible then select View - Toolbox. Now
you
can just drag a text box or combo box directly onto the form...if the
problem
deals with Essbase somehow just let me know...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have created a form in Visual Basic and for the life of me I cannot
figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks

Insert Listbox in Essbase Form
 

No!

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
THanks, I found that eventually, the help file is not much help at all, I
do
have one other question tho is it possible to manually enter values into
the
row source

Thanks


"Tom Ogilvy" wrote:

sheet1!A1:A6

where sheet1 represents the tab name.

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
OK thanks Jim, for some unknown reason I couldn't view the toolbox, Can
I
type my own values in the control source or do I have to reference a
range
of
cells on a worksheet

I tried the following but it din't like it as the control source

sheets.lists.range("a1:a6")



"Jim Thomlinson" wrote:

Not too sure what you are looking for or how it relates to Essbase but
here
goes... I assume that we are discussing a userform. I assume that you
have a
userform created (Insert - UserForm). You now have a blank userform
on
the
screen. If your toolbox is not visible then select View - Toolbox.
Now
you
can just drag a text box or combo box directly onto the form...if the
problem
deals with Essbase somehow just let me know...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I have created a form in Visual Basic and for the life of me I
cannot
figure
out how to install a list box or even a text box on the form

Can someone point me in the right direction

Thanks