ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy Column Width (https://www.excelbanter.com/excel-programming/444543-re-copy-column-width.html)

Steve[_4_]

Copy Column Width
 
Works for me. Thank you, Sir!!

On Wednesday, May 4, 2011 5:08:35 PM UTC-6, GS wrote:
It happens that Steve formulated :
Hey Garry,

One last quick one if I may...can I replace a "blank" entry in my textbox
(upon clicking the ok button) with a timestamp (or something unique)?


Something like...?

Private Sub cmdOK_Click()
Dim sTemp
If Me.TextBox1.Text = "" Then
' sTemp = Now() '//date and time
sTemp = TimeValue(Now()) '//time only
Else
sTemp = Me.TextBox1.Text
End If
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



GS[_2_]

Copy Column Width
 
You're still welcome!<g

BTW, you're still making new posts when you reply. Makes it rather hard
to manage when everything's not under one topic thread. Can you look
into sorting that out, please?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc




All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com