General discussion

Locked

Microsoft Office suite Q&A

By discussion ·
Office suite users and support analysts, use this space to consult with other Office users and analysts, post your questions, offer your comments on the Microsoft Office Suite e-newsletter, or suggest future Office tips.

If you'd like to check out the previous Office suite Q&A discussions for answers, here are the links:

- http://techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=122381

- http://techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=130431

If you're not subscribed to the Microsoft Office Suite e-newsletter, you can check it out here, under Technical Tips:
http://nl.com.com/guest.jsp?brand=techrepublic&return_to=http://techrepublic.com.com:8001/2001-1-0.html

*When pasting these links into your browser, remember to remove any spaces.

This conversation is currently closed to new comments.

16 total posts (Page 2 of 2)   Prev   01 | 02
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Using VB to set time and date

by eisley_rodrigues In reply to Inserting date and time f ...

In your form design view, right on cmdRes, then select "Build Event", a pop up box will appear. select "Code Builder"

The code for your application will look like this

Private Sub cmdRes_Click()

[resTime].text = Now()
[resDate].text = Now()

End Sub

Back in design view, you can select the spefic formatting for the date and time fields you have just created.

Hope this helps

Collapse -

Inserting date and time from a command button

by rleavitt In reply to Inserting date and time f ...

Private Sub cmdres_Click()
Forms![test].restime = Time()
Forms![test].resdate = Date()
End Sub

I used test as the name of your form

Collapse -

Excel

by mschapiro In reply to Microsoft Office suite Q& ...

When a date is put into a field and you tab over to the next field over, the field with the date changes to pound signs.

Collapse -

by juliang In reply to Excel

Just resize the column width.

Collapse -

Min/Max Across Multiple Sheets

by waresfamily In reply to Microsoft Office suite Q& ...

Is it possible to use a function/macro to find the maximum value in multiple sheets in a single workbook?

Collapse -

Don't see why not

by nickrusso In reply to Min/Max Across Multiple S ...

Try syntax =MAX(sheet1![range],sheet2![range],...).

Dont't forget the bang! after the sheet name, or just click and select the sheet and range you want, comma, then repeat for next area.

Back to Software Forum
16 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums