Does anybody know a good multiline inputbox that I can use in VBA?
Ideally with a richtext control.
It should be easy to do this with a userform, but trying to save some time.
Thanks.

RBS

Does anybody know a good multiline inputbox that I can use in VBA?
Ideally with a richtext control.
It should be easy to do this with a userform, but trying to save some
time. Thanks.

RBS

Userform is the way to go since you're obviously looking for something
very custom. Once done the component is reusable for other projects.

The folks I bought my Spread.ocx from (Farpoint) included a custom
InputBox.ocx but that's not the way to go, IMO, because the control
needs to be registered! (You were looking for something 3rd party, I
assume)

Note that the Windows Common Controls install with all versions of MS
Office and so anything from that lib works well on MSO Userforms.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

OK, will be userform then.
Maybe in VB6 as an activeX dll because there are security problems
with the richtext control in VBA userforms.

RBS


On Wednesday, 18 March 2015 12:48:06 UTC, wrote:
Does anybody know a good multiline inputbox that I can use in VBA?
Ideally with a richtext control.
It should be easy to do this with a userform, but trying to save some time.
Thanks.

RBS

Maybe in VB6 as an activeX dll because there are security problems
with the richtext control in VBA userforms.

Do you mean beyond normal macro security? Please elaborate...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Many years ago I had a richtext control (the standard MS one) on a userform
and I had problems as the control was not trusted. Not to do with macro security. Since then I have been using a customized control (based on the standard one) with no problems. Have posted several times about this, years ago and it should be traceable.

RBS

Do you mean beyond normal macro security? Please elaborate...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Many years ago I had a richtext control (the standard MS one) on a
userform
and I had problems as the control was not trusted. Not to do with
macro security. Since then I have been using a customized control
(based on the standard one) with no problems. Have posted several
times about this, years ago and it should be traceable.

Yes, I'm aware of the warning displayed when the userform initially
loads. But that only happens once during runtime. I suppose that's once
too many, though!

What about using the Registry fix you got from KouKour back then? Seems
easier to go that way than build a custom control, IMO?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

What about using the Registry fix you got from KouKour back then?

Can't remember that one and will have a look at it.

RBS


On Wednesday, 18 March 2015 18:19:30 UTC, GS wrote:
Many years ago I had a richtext control (the standard MS one) on a
userform
and I had problems as the control was not trusted. Not to do with
macro security. Since then I have been using a customized control
(based on the standard one) with no problems. Have posted several
times about this, years ago and it should be traceable.

Yes, I'm aware of the warning displayed when the userform initially
loads. But that only happens once during runtime. I suppose that's once
too many, though!

What about using the Registry fix you got from KouKour back then? Seems
easier to go that way than build a custom control, IMO?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion