I have a userform with some texboxes and comboboxes. If the user types or
select something, that data will be written to cells. (Sheet1A1, Sheet2B15,
Sheet3K29, etc.)
That input must be checked before it can be stored in the database. If the
cells doesn't contain proper data, the commandbutton1 must be disabled. I
would like to know how create a macro that checks all these specific cells.
Should I use select case?

Thanks for helping, Gert-Jan

How will you initiate the checks. Normally it would be clicking a button,
such as the OK button, then just look at each value and test it. If they are
okay, write them away, else throw up an error message.

Select Case might be a strategy, but there is too little info to advise.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gert-Jan" <(E-Mail Removed)> wrote in message
news:4535eae1$0$27817$(E-Mail Removed)...
> I have a userform with some texboxes and comboboxes. If the user types or
> select something, that data will be written to cells. (Sheet1A1,
Sheet2B15,
> Sheet3K29, etc.)
> That input must be checked before it can be stored in the database. If the
> cells doesn't contain proper data, the commandbutton1 must be disabled. I
> would like to know how create a macro that checks all these specific
cells.
> Should I use select case?
>
> Thanks for helping, Gert-Jan
>
>

The situation is like this:

- in the userform are textboxes and comboboxes (total: 6)
- if the user types or selects something (on change), the data will be
written to a sheet (that will happen on 6 places)

I want a macro that will run (also on change of one of texboxes /
comboboxes) and check if the filled in / selected data is proper.

A sort function like this

Sub check()
If range (Sheet1!D5).value = 1 OR
If range (Sheet2!D8).value = 0 OR
etc
CommandButton1.enabled = false

I have never worked with caseselect-functions, any help would be nice ;-)

"Bob Phillips" <(E-Mail Removed)> schreef in bericht
news:%(E-Mail Removed)...
> How will you initiate the checks. Normally it would be clicking a button,
> such as the OK button, then just look at each value and test it. If they
> are
> okay, write them away, else throw up an error message.
>
> Select Case might be a strategy, but there is too little info to advise.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Gert-Jan" <(E-Mail Removed)> wrote in message
> news:4535eae1$0$27817$(E-Mail Removed)...
>> I have a userform with some texboxes and comboboxes. If the user types or
>> select something, that data will be written to cells. (Sheet1A1,
> Sheet2B15,
>> Sheet3K29, etc.)
>> That input must be checked before it can be stored in the database. If
>> the
>> cells doesn't contain proper data, the commandbutton1 must be disabled. I
>> would like to know how create a macro that checks all these specific
> cells.
>> Should I use select case?
>>
>> Thanks for helping, Gert-Jan
>>
>>
>
>

And, of course: if the values are Ok, CommandButton1.enabled = True

"Gert-Jan" <(E-Mail Removed)> schreef in bericht
news:4535f89f$0$27821$(E-Mail Removed)...
> The situation is like this:
>
> - in the userform are textboxes and comboboxes (total: 6)
> - if the user types or selects something (on change), the data will be
> written to a sheet (that will happen on 6 places)
>
> I want a macro that will run (also on change of one of texboxes /
> comboboxes) and check if the filled in / selected data is proper.
>
> A sort function like this
>
> Sub check()
> If range (Sheet1!D5).value = 1 OR
> If range (Sheet2!D8).value = 0 OR
> etc
> CommandButton1.enabled = false
>
> I have never worked with caseselect-functions, any help would be nice ;-)
>
> "Bob Phillips" <(E-Mail Removed)> schreef in bericht
> news:%(E-Mail Removed)...
>> How will you initiate the checks. Normally it would be clicking a button,
>> such as the OK button, then just look at each value and test it. If they
>> are
>> okay, write them away, else throw up an error message.
>>
>> Select Case might be a strategy, but there is too little info to advise.
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (replace somewhere in email address with gmail if mailing direct)
>>
>> "Gert-Jan" <(E-Mail Removed)> wrote in message
>> news:4535eae1$0$27817$(E-Mail Removed)...
>>> I have a userform with some texboxes and comboboxes. If the user types
>>> or
>>> select something, that data will be written to cells. (Sheet1A1,
>> Sheet2B15,
>>> Sheet3K29, etc.)
>>> That input must be checked before it can be stored in the database. If
>>> the
>>> cells doesn't contain proper data, the commandbutton1 must be disabled.
>>> I
>>> would like to know how create a macro that checks all these specific
>> cells.
>>> Should I use select case?
>>>
>>> Thanks for helping, Gert-Jan
>>>
>>>
>>
>>
>
>