Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

optionbutton/msgbox/input box

26 views
Skip to first unread message

Dick

unread,
Apr 13, 2011, 4:26:25 PM4/13/11
to
I have a spreadsheet that has a optionbutton1 labeled Yes. I'd like
for when the user selects yes for a msgbox to pop up and an input box
for the user to input a time and the results be sent to Sheet1 Cell
C1. The time format is I'd like is 0:00:0 or h:mm:ss Thanks so much
for any help!!!

MikeD

unread,
Apr 14, 2011, 7:03:06 PM4/14/11
to

"Dick" <bobd...@yahoo.com> wrote in message
news:508e3679-16fc-49e8...@a19g2000prj.googlegroups.com...

You'll get better help in an Excel newsgroup (assuming that's the
spreadsheet you mean). This newsgroup is for the full Visual Basic product
rather than VBA.

However, if I were doing this in a VB app, I would NOT show an input box.
I'd put a DTPicker control next to the option button and enable the DTPicker
when that option button was chosen (and then of course disable the DTPicker
when any other option button within the group was chosen).

Perhaps you can do something like that in Excel.

--
Mike

Dick

unread,
Apr 15, 2011, 4:45:55 PM4/15/11
to
On Apr 14, 7:03 pm, "MikeD" <nob...@nowhere.edu> wrote:
> "Dick" <bobde...@yahoo.com> wrote in message

What is a DTPicker?

MikeD

unread,
Apr 15, 2011, 5:05:46 PM4/15/11
to

"Dick" <bobd...@yahoo.com> wrote in message

news:bf32f721-ef8d-444b...@j9g2000prj.googlegroups.com...

It a DateTimePicker. It's a control built-in to Windows and exposed for COM
use via the Windows Common Controls 2 OCX. It is specifically intended to
allow a user to choose a date and/or time. I can't tell you how you might be
able to use this control in Excel, if in fact you can at all. You need to
ask in an Excel newsgroup or Excel forum.

--
Mike

ralph

unread,
Apr 15, 2011, 5:16:12 PM4/15/11
to
On Fri, 15 Apr 2011 13:45:55 -0700 (PDT), Dick <bobd...@yahoo.com>
wrote:

A "Date and Time Picker" or "MS Calendar Control" ActiveX control.

There can be some confusion as it (or them) comes in multiple versions
and with various packages/products. A version comes with Excel for use
with Excel VBA, but it might be an optional install. They can also be
download.

Which version of this control would be appropriate for you depends on
your version of Excel.

-ralph

MikeD

unread,
Apr 19, 2011, 7:41:05 AM4/19/11
to

"ralph" <nt_cons...@yahoo.net> wrote in message
news:cochq6dj0g455vj48...@4ax.com...


>>
>>What is a DTPicker?
>
> A "Date and Time Picker" or "MS Calendar Control" ActiveX control.
>
> There can be some confusion as it (or them) comes in multiple versions
> and with various packages/products. A version comes with Excel for use
> with Excel VBA, but it might be an optional install. They can also be
> download.
>
> Which version of this control would be appropriate for you depends on
> your version of Excel.
>


I don't think the MS Calendar Control has any time functionality, solely
dates. So, it doesn't sound like it would suit his needs.

--
Mike

0 new messages