MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Access Function In Another Sheet

  Asked By: Ronnie    Date: Feb 08    Category: MS Office    Views: 1423

I have searched on google but could not find answer. I am looking for
how to call Public function in a sheet "Data-Sheet" from another sheet
"OutputSheet". I have tried the following code which didn't work for me.

'in OutputSheet
dim s as string
Dim ws as worksheet
set ws=worksheet("Data-Sheet")
s=ws.GetHeadingDetails 'Where GetHeadingDetails is a fucntion.

Please reply ASAP. I am running late for this project. .....tight



1 Answer Found

Answer #1    Answered By: Vidhya Iyer     Answered On: Feb 08

I would have expected this to work, but you might not have time to play

So simply move the function  to a code  module and call  it from both sheets.

Note that you haven't said what the actual "didn't work" was, so I'm not
sure how you expect us to guess the answer. What precisely went wrong?

Remember that the active sheet  would be OutputSheet, not DataSheet, when the
function was executed in this way.

Didn't find what you were looking for? Find more on Access Function In Another Sheet Or get search suggestion and latest updates.