UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> If And Else Not Recognise Format Tttt, Office 2013    
 
   
kenwood1
post Feb 19 2020, 06:01 AM
Post#1



Posts: 512
Joined: 11-July 09



Hi all,

Below are a small program. I have in a cell DO3 A Formular =today()-4 and Format TTTT which show only the week Monday through Sunday. If I only type on the cell the DO3 without the Formular it works, but when I use the Formular =today()-4 in the cell DO3 …. it only tell me "Not Friday" even the cell with the formular Show Friday.


Dim T As String


T = "Friday"


If Not Range("DO3").Value = T Then

MsgBox "Not Friday"

Else
MsgBox "Today is Freitag"

End If



Help is needed.
Thanks in advance
Go to the top of the page
 
cheekybuddha
post Feb 19 2020, 06:11 AM
Post#2


UtterAccess Moderator
Posts: 12,817
Joined: 6-December 03
From: Telegraph Hill


Hi,

Try this:
CODE
' ...
  If Not Range("DO3").Text = T Then
' ...

--------------------


Regards,

David Marten
Go to the top of the page
 
kenwood1
post Feb 19 2020, 06:20 AM
Post#3



Posts: 512
Joined: 11-July 09



Wonderfull, Thank you so much thumbup.gif
Go to the top of the page
 
cheekybuddha
post Feb 19 2020, 06:20 AM
Post#4


UtterAccess Moderator
Posts: 12,817
Joined: 6-December 03
From: Telegraph Hill


yw.gif

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    2nd June 2020 - 06:03 AM